IS_INFINITE
All functions > MATH > IS_INFINITE
Checks if a number is infinite (positive or negative infinity).
Syntax
IS_INFINITE(number: T) → BOOLEANsql
Type Parameters:
T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
number | T | Yes | The number to check |
Returns
BOOLEAN - TRUE if infinite, FALSE otherwise
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