4 ms·
With so much to love in PG 12 I can't wait to see what they do in PG 13.
by gigatexal 7y ago
With so much to love in PG 12 I can't wait to see what they do in PG 13.
- ainar-g 7y agoMERGE[1], hopefully. If I understand correctly, it would allow us to do upserts while checking against multiple conditions. It's also standard SQL, unlike UPSERT, INSERT OR REPLACE, INSERT … ON CONFLICT, and all the other names different RDBMSes gave it over the years. [1] https://en.wikipedia.org/wiki/Merge_(SQL) https://en.wikipedia.org/wiki/Merge_(SQL)
- gigatexal 7y agoI’m all about the single keyword and it being standard compliant.