Comment on PostgreSQL vs. MS SQLComments−codexon11yWhat about the lack of upsert in PostgreSQL?−dozzie11yWell, the same as the lack of upsert in SQL Server. Bear in mind that UPSERT != MERGE.http://www.postgresql.org/message-id/CAM3SWZRP0c3g6+aJ=YYDGY...−swasheck11yyeah. sql server's `MERGE` is hacky.http://sqlperformance.com/2013/02/t-sql-queries/another-merg...
Comments
What about the lack of upsert in PostgreSQL?
Well, the same as the lack of upsert in SQL Server. Bear in mind that UPSERT != MERGE.
http://www.postgresql.org/message-id/CAM3SWZRP0c3g6+aJ=YYDGY...
yeah. sql server's `MERGE` is hacky.
http://sqlperformance.com/2013/02/t-sql-queries/another-merg...