In PostgreSQL, the COALESCE function is used to return the first non-null expression in a list of expressions. It is a very useful function for handling cases where you want to obtain the first non-null value from a set of possible values.
 
Example:

SELECT COALESCE(null, 42, 'Hello'); -- Returns 42