Numbers & math
Scalar
isinf()
Returns true if the floating point value is infinite, false otherwise
Reference: DuckDB 2.0.0
Arguments & returns
5 overloadsisinf(x)
Scalar
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
In other engines
Used in larger rewrites 1
These examples use isinf as one part of a larger SQL translation.
Snowflaketo_boolean()
SELECT To_BOOLEAN('T')
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