Skip to main content
Returns TRUE if the argument is finite, and FALSE otherwise. Only REAL and DOUBLE PRECISION types can represent infinity in Firebolt, meaning that IS_FINITE will always return TRUE for NUMERIC inputs.

​
Syntax

IS_FINITE(<value>);

​
Parameters

ParameterDescriptionSupported input types
<value>The input that will be checked to determine if it is a finite number.NUMERIC, DOUBLE PRECISION, REAL

​
Return Type

IS_FINITE returns a value of type BOOLEAN.

​
Examples

The following example checks whether the value inf, after being cast to a DOUBLE PRECISION data type, is a finite number: 
SELECT IS_FINITE('inf'::DOUBLE PRECISION);
is_finite boolean
False

Rows: 1Execution time: 6.08ms

The following code example checks whether the value 10, after being cast to a REAL data type, is an infinite number: 
SELECT IS_FINITE(10::REAL);
is_finite boolean
True

Rows: 1Execution time: 5.42ms