Functions/Database & utility/error
Database & utility Scalar

error()

Throws the given error message

Arguments & returns

error(message)

Scalar
Overload link message Returns
#01 VARCHAR "NULL"

Catalog examples

SELECT
  error('access_mode');

In other engines

Used in larger rewrites 1

These examples use error 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 ↗