SQLzoo.net

Replace a NULL with a specific value

Postgres
The SQL standard is COALESCE	SELECT code, name, COALESCE(leader, 'NO LEADER RECORDED!') FROM party
Specific to Postgres
COALESCE takes any number of arguments, it returns the first which is not null.