Functions / Comparison Functions And Operators

error_on_null

Checks if the input is the null value, generating an error if so; otherwise, returns the input.

Reading PG 20devel·documented in 2 of 27 versions, 19 to 20

Development snapshot. These definitions may change before release.

Signatures & examples

error_on_null ( anyelement ) → anyelement

Checks if the input is the null value, generating an error if so; otherwise, returns the input.

error_on_null(42) → 42

error_on_null(row(null,null)) → (,)

Version history 1

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source