CODE EXAMPLE FOR SQL

coalesce postgresql

COALESCE (argument_1, argument_2, …);
The COALESCE function accepts an unlimited number of arguments. 
It returns the first argument that is not null. If all arguments are null, 
the COALESCE function will return null.