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
- This function benefits from a range index.
See also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for