Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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: The following code example checks whether the value 10, after being cast to a REAL data type, is an infinite number: