Eine Einführung in

SQL

Replace a NULL with a specific value

PostgreSQL
The SQL standard is COALESCE


Specific to PostgreSQL
COALESCE takes any number of arguments, it returns the first which is not null.