coalesce postgresql code example

Example 1: nvl postgres

COALESCE (argument_1, argument_2, …);Code language: SQL (Structured Query Language) (sql)

Example 2: 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.