PostgreSQL Function Reference

NULLIF

Returns null if two values are equal.

PostgreSQL 17.5

NULLIF(value_1, value_2)

value_1

First value

value_2

Second value

Examples

PostgreSQL 17.5

SELECT NULLIF('SQL Academy', 'SQL Academy')