IS_INFINITE

All functions > MATH > IS_INFINITE

Returns TRUE if a number is infinite (positive or negative infinity).

Signatures

Returns: TRUE if infinite, FALSE otherwise

IS_INFINITE(number: T) → BOOLEAN

Notes

• Returns TRUE for both positive and negative infinity
• Returns FALSE for finite numbers, zero, and NaN
• Returns NULL if input is NULL
• Useful for detecting overflow conditions
• Complement to IS_FINITE for infinity cases

Examples

SELECT
    f1 := IS_INFINITE(42.5),  -- Regular number is not infinite
    f2 := IS_INFINITE(INFINITY()),  -- Positive infinity
    f3 := IS_INFINITE(NAN())  -- NaN is not infinite
;