IS_INFINITE

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

IS_FINITE(<value>);

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

Example

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

SELECT
    IS_INFINITE('inf'::DOUBLE PRECISION);

Returns

The previous code example returns TRUE because infinity is an infinite value.

EXAMPLE

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

SELECT
    IS_INFINITE(10::REAL);

Returns

The previous code example returns FALSE because 10 is a finite value.