IS_FINITE

All functions > MATH > IS_FINITE

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

Syntax

IS_FINITE(number: T) → BOOLEAN

Type Parameters:

• T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)

Arguments

Returns

BOOLEAN - TRUE if finite, FALSE if infinite or NaN

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