Coalesce in Postgres

Posted by yhuang

Public (Editable by Users)

Returns the first non null value.

Language SQL

Dependencies

None

SELECT COALESCE (1, 2);         // 1
SELECT COALESCE (NULL, 2 , 1);  // 2