IS_FINITE_NUMBER (NoSQL query)

The IS_FINITE_NUMBER function returns a boolean indicating if a number is a finite number (not infinite).

An Azure Cosmos DB for NoSQL system function that returns a boolean indicating if a number is a countable (finite) number.

Syntax

IS_FINITE_NUMBER(<numeric_expr>)

Arguments

Return types

Returns a boolean.

Examples

This section contains examples of how to use this query language construct.

Check if number is finite

In this example, the IS_FINITE_NUMBER function is demonstrated 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

• This function benefits from the use of a range index. For more information, see range indexes.