Numbers & math Scalar

isnan()

Returns true if the floating point value is not a number, false otherwise

Arguments & returns

2 overloads

Scalar

Overload link	`x`	Returns
#01	`DOUBLE`	`BOOLEAN`
#02	`FLOAT`	`BOOLEAN`

SELECT isnan('NaN'::FLOAT);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

IS_NAN(x)

In DuckDB

ISNAN(x)

Used in larger rewrites 1

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

SELECT CORR(a, b)

In DuckDB

SELECT CASE WHEN ISNAN(CORR(a, b)) THEN NULL ELSE CORR(a, b) END