Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
От | Andres Freund |
---|---|
Тема | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} |
Дата | |
Msg-id | 20140929070235.GP1169@alap3.anarazel.de обсуждение исходный текст |
Ответ на | Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} (Heikki Linnakangas <hlinnakangas@vmware.com>) |
Ответы |
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: