Premium
Log in
PostgreSQL Function Reference
COALESCE
Returns the first non-null value from a list.
PostgreSQL 17.5
COALESCE(val1[, val2, ...., val_n])val1
Values to check
Examples
PostgreSQL 17.5
SELECT COALESCE(NULL, NULL, 1, 2)COALESCE(val1[, val2, ...., val_n])SELECT COALESCE(NULL, NULL, 1, 2)