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:NULLIF
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:
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- group
- conditional
- group label
- Conditional Expressions
- lang
- en
- layout
- table-new
- pages
- functions-conditional.html
- prose only
- false
Definition PG 18
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:Signatures and overloads
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:daf860680354c62c9cb40463130eb135b0d8edadefa706973559d4afcf598405
Text language: en · wiki-repair-20261023:daf860680354c62c9cb40463130eb135b0d8edadefa706973559d4afcf598405