Редактиране

Споделяне чрез

IS_FINITE_NUMBER (NoSQL query)

  • Статия

APPLIES TO: NoSQL

Returns a boolean indicating if a number is a finite number (not infinite).

Syntax

IS_FINITE_NUMBER(<numeric_expr>)

Arguments

Description
numeric_expr A numeric expression.

Return types

Returns a boolean.

Examples

This example demonstrates the function with various static values.

SELECT VALUE {
    finiteValue: IS_FINITE_NUMBER(1234.567),
    infiniteValue: IS_FINITE_NUMBER(8.9 / 0.0),
    nanValue: IS_FINITE_NUMBER(SQRT(-1.0))
}

[
  {
    "finiteValue": true,
    "infiniteValue": false,
    "nanValue": false
  }
]

Remarks

See also