Answers for "psql coalesce"

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.

nvl postgres

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