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
    f1 := IS_FINITE(42.5E0), -- Regular number
    f2 := IS_FINITE(0.0E0), -- Zero
    f3 := IS_FINITE(INFINITY()), -- Infinity
    f4 := IS_FINITE(NAN()) -- NaN
;