On 2014-09-29 09:51:45 +0300, Heikki Linnakangas wrote: > That said, it would be handy if the syntax was closer to MERGE. Aside from > the concurrency issues, it does the same thing, right? So how about making > the syntax identical to MERGE, except for swapping the MERGE keyword with > e.g. UPSERT?
I don't think that's a good idea. What most people are missing is an *easy* way to do upsert, that's similar to the normal INSERT. Not something with a pretty different syntax. That's why INSERT OR REPLACE and stuff like that was well adopted. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
