COALESCE:
*Single non null argument
Single non null argument
suggest changePGSQL> SELECT COALESCE(NULL, NULL, 'HELLO WORLD');
coalesce
--------
'HELLO WORLD'
Found a mistake? Have a question or improvement idea?
Let me know.
PGSQL> SELECT COALESCE(NULL, NULL, 'HELLO WORLD');
coalesce
--------
'HELLO WORLD'