[PostgreSQL] COALESCE
WHAT IS COALESCE()?
In simple terms, COALESCE() helps you choose the first non-null alue from a list.
BASIC SYNTAX
COALESCE(value1, value2, value3, ...)
It checks each value in order and returns the first one that is not NULL.
SIMPLE EXAMPLES
-- exa...
q1.hashnode.dev2 min read