Tutorial by Examples

Single non null argument

PGSQL> SELECT COALESCE(NULL, NULL, 'HELLO WORLD'); coalesce -------- 'HELLO WORLD'

Multiple non null arguments

PGSQL> SELECT COALESCE(NULL, NULL, 'first non null', null, null, 'second non null'); coalesce -------- 'first non null'

All null arguments

PGSQL> SELECT COALESCE(NULL, NULL, NULL); coalesce --------

Page 1 of 1

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.