IS_INFINITE()

All functions > MATH > IS_INFINITE()

Returns TRUE if a floating-point number is infinite (positive or negative).

Signatures

Infinity check

Returns: TRUE if infinite, FALSE otherwise

IS_INFINITE(number: T) → BOOLEAN

With:

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

Signature notes:

• Returns TRUE for both positive and negative infinity
• Returns FALSE for finite numbers and NaN
• Returns NULL if the input is NULL
• Only defined for FLOAT and DOUBLE

Examples

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