IS_PRIMITIVE (Azure Cosmos DB)IS_PRIMITIVE (Azure Cosmos DB)
适用于:
SQL API
返回一个布尔值,指示指定表达式的类型是否为一个(字符串、布尔、数值或 null)。Returns a Boolean value indicating if the type of the specified expression is a primitive (string, Boolean, numeric, or null).
语法Syntax
IS_PRIMITIVE(<expr>)
参数Arguments
exprexpr
是任何表达式。Is any expression.
返回类型Return types
返回一个布尔表达式。Returns a Boolean expression.
示例Examples
以下示例使用 IS_PRIMITIVE
函数检查 JSON 布尔、数字、字符串、null、对象、数组和 undefined 类型的对象。The following example checks objects of JSON Boolean, number, string, null, object, array and undefined types using the IS_PRIMITIVE
function.
SELECT
IS_PRIMITIVE(true) AS isPrim1,
IS_PRIMITIVE(1) AS isPrim2,
IS_PRIMITIVE("value") AS isPrim3,
IS_PRIMITIVE(null) AS isPrim4,
IS_PRIMITIVE({prop: "value"}) AS isPrim5,
IS_PRIMITIVE([1, 2, 3]) AS isPrim6,
IS_PRIMITIVE({prop: "value"}.prop2) AS isPrim7
下面是结果集。Here is the result set.
[{"isPrim1": true, "isPrim2": true, "isPrim3": true, "isPrim4": true, "isPrim5": false, "isPrim6": false, "isPrim7": false}]
备注Remarks
此系统函数将从范围索引中获益。This system function will benefit from a range index.