Categories

Archives

Did You Know?

I'm a purist when it comes to RESTful web services and, even though I'm guilty of it myself, am often disappointed by how loosely the term is applied to more RPC-style APIs.

Recent Comments

Tags

asp audio browser bug business coalesce code crash Database db debian extension framework imap internet legions linux metaverse mysql obscurity patch PHP postgresql properties release scp Second Life second life security session social media sound sql ssh subversion tables tortoisesvn tribes ubuntu virtual world web windows zend zend framework zf

Tag: 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 not as flexible). This comes in handy when you want to use fallback values in […]