Re: INSERT OU UPDATE WITHOUT SELECT?

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: INSERT OU UPDATE WITHOUT SELECT?
Дата
в 19:35:14
Msg-id
op.tadyc1jwcigqcu@apollo13
Ответ на
Список
Дерево обсуждения
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
Дата:
От: PFC
Дата:
FAQ