Re: INSERT OU UPDATE WITHOUT SELECT?
От
PFC
Тема
Re: INSERT OU UPDATE WITHOUT SELECT?
Дата
Msg-id
op.tadyc1jwcigqcu@apollo13
Ответ на
Re: INSERT OU UPDATE WITHOUT SELECT? (Jonah H. Harris)
Список
Дерево обсуждения
INSERT OU UPDATE WITHOUT SELECT? Waldomiro <waldomiro@shx.com.br>
Re: INSERT OU UPDATE WITHOUT SELECT? "Jonah H. Harris" <jonah.harris@gmail.com>
Re: INSERT OU UPDATE WITHOUT SELECT? PFC <lists@peufeu.com>
Re: INSERT OU UPDATE WITHOUT SELECT? "Dave Dutcher" <dave@tridecap.com>
Re: INSERT OU UPDATE WITHOUT SELECT? "D'Arcy J.M. Cain" <darcy@druid.net>
Re: INSERT OU UPDATE WITHOUT SELECT? "Jim C. Nasby" <jnasby@pervasive.com>
Re: INSERT OU UPDATE WITHOUT SELECT? Alvaro Herrera <alvherre@commandprompt.com>
> PostgreSQL does not support MERGE at the moment, sorry. Issue an UPDATE, and watch the rowcount ; if the rowcount is 0, issue an INSERT. Be prepared to retry if another transaction has inserted the row meanwhile, though. MERGE would be really useful.
В списке pgsql-performance по дате отправления
От: Daniel J. Luke
Дата: