使用PostgreSQL 9.3在CTE UPSERT中生成DEFAULT值

I'm finding that using writable CTEs to emulate an upsert in PostgreSQL to be quite an elegant solution until we get actual upsert/merge in Postgres. (see: I'm finding that using writable CTEs to emulate