Skip to main content
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

​
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:

Rows: 1Execution time: 5.49ms

The following code example checks whether the value 10, after being cast to a REAL data type, is an infinite number:

Rows: 1Execution time: 8.53ms