select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / COMPARISON FUNCTIONS AND OPERATORS

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

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
  1. PG 18 → 19added

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