IS_FINITE

All functions > MATH > IS_FINITE

Returns TRUE if a number is finite (not infinite and not NaN).

Signatures

Returns: TRUE if finite, FALSE if infinite or NaN

IS_FINITE(number: T) → BOOLEAN

Notes

• Returns TRUE for all regular numbers (positive, negative, zero)
• Returns FALSE for positive infinity, negative infinity, and NaN
• Returns NULL if input is NULL
• Useful for filtering out problematic floating-point values
• Opposite of IS_INFINITE for infinity cases

Examples

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