News for hackers. Stuff that matters.
Re:Upsert Lands in PostgreSQL 9.5 – A First Look by ryanjshaw on Wednesday May 13, 2015 @12:50PM (#9540229)
This implementation of upsert is especially nice because it is atomic [1]:

    <literal>ON CONFLICT DO UPDATE</literal> guarantees an atomic
    <command>INSERT</command> or <command>UPDATE</command> outcome - provided
    there is no independent error, one of those two outcomes is guaranteed,
    even under high concurrency.
I don't know about Oracle or MySQL, but the SQL Server implementation of MERGE requires you to carefully consider which locks to use and it's very easy to shoot yourself in the foot with.

[1] http://git.postgresql.org/gitweb/?p=postgresql.git;a=blobdif...

There are no comments on this comment yet.