Numeric functions
IS_INFINITE
Reference material for the IS_INFINITE function
Returns TRUE if the argument is infinite, and FALSE otherwise. Only REAL and DOUBLE PRECISION types can represent infinity in Firebolt, meaning that IS_INFINITE will always return FALSE for NUMERIC inputs.
Syntax
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value> | The input that will be checked to determine if it is an infinite number. | NUMERIC, DOUBLE PRECISION, REAL |
Return Type
IS_INFINITE returns a value of type BOOLEAN.
Examples
The following code example checks whether the value inf, after being cast to a DOUBLE PRECISION data type, is an infinite number:
The following code example checks whether the value 10, after being cast to a REAL data type, is an infinite number: