INFINITY()

All functions > MATH > INFINITY()

Returns the floating-point representation of positive infinity.

Signatures

Positive infinity

Returns: Positive infinity

INFINITY() → DOUBLE

Signature notes:

• Greater than any finite number
• INFINITY() + x = INFINITY() for any finite x

Examples

SELECT
    f1 := IS_INFINITE(INFINITY()) -- Positive infinity is infinite
;