NULLIF(value1, value2)The
NULLIF function returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the inverse operation of the COALESCE example given above:FUNCTIONS / CONDITIONAL EXPRESSIONS
NULLIF
Read PG 18 manual ↗The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1.
Signatures & examples
Version history 1
- PG 12 → 13changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source