Functions/Numbers & math/isinf
Numbers & math Scalar

isinf()

Returns true if the floating point value is infinite, false otherwise

Arguments & returns

5 overloads

isinf(x)

Scalar
Overload link x Returns
#01 DATE BOOLEAN
#02 DOUBLE BOOLEAN
#03 FLOAT BOOLEAN
#04 TIMESTAMP BOOLEAN
#05 TIMESTAMP WITH TIME ZONE BOOLEAN

Example

isinf example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

BigQueryis_inf()

IS_INF(x)
In DuckDB
ISINF(x)

SQLGlot example ↗

Used in larger rewrites 1

These examples use isinf as one part of a larger SQL translation.

Snowflaketo_boolean()

SELECT To_BOOLEAN('T')
In DuckDB
SELECT CASE WHEN UPPER(CAST('T' AS TEXT)) = 'ON' THEN TRUE WHEN UPPER(CAST('T' AS TEXT)) = 'OFF' THEN FALSE WHEN ISNAN(TRY_CAST('T' AS REAL)) OR ISINF(TRY_CAST('T' AS REAL)) THEN ERROR('TO_BOOLEAN: Non-numeric values NaN and INF are not supported') ELSE CAST('T' AS BOOLEAN) END

SQLGlot example ↗