IS_FINITE()

All functions > MATH > IS_FINITE()

Returns TRUE if a floating-point number is finite (neither infinite nor NaN).

Signatures

Finite check

Returns: TRUE if finite, FALSE if infinite or NaN

IS_FINITE(number: T) → BOOLEAN

With:

• T : Floating-point type (FLOAT, DOUBLE)

Signature notes:

• Returns TRUE for all regular numbers including zero
• Returns FALSE for positive infinity, negative infinity, and NaN
• Returns NULL if the input is NULL
• Only defined for FLOAT and DOUBLE; integer types cannot be infinite or NaN

Examples

SELECT
    -- Regular number
    f1 := IS_FINITE(42.5e0),
    -- Zero
    f2 := IS_FINITE(0.0e0),
    -- Infinity
    f3 := IS_FINITE(INFINITY()),
    -- NaN
    f4 := IS_FINITE(NAN())
;