Functions / Conditional Expressions

NULLIF

The NULLIF function returns a null value if value1 equals value2; otherwise it returns value1.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

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:

Version history 4

12 → 13 changed
8.3 → 8.4 changed
8.0 → 8.1 changed
7.2 → 7.3 changed

Definition snapshot: b7bd9cda · English manual source