Tag Archives: coalesce

PostgreSQL-style COALESCE() in PHP

There's a rather handy command in Oracle, PostgreSQL, SQLite, and MySQL (since version 3.23.3) called COALESCE(). Its purpose is rather simple: return the first non-NULL value (If you're used to older versions of MySQL, the IFNULL() is quite similar, if … Continue reading

Posted in PHP | Tagged , , | 1 Comment