I really wish PostgreSQL had a MERGE command. This would save me from a lot of contortions I've had to do recently. At least they seem to be working on it, I guess ...

BANGALORE, INDIA: In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement.