Re: Adding MERGE to the TODO list (resend with subject)

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Adding MERGE to the TODO list (resend with subject)
Дата
Msg-id 409D8E48.3070805@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Adding MERGE to the TODO list (resend with subject)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Adding MERGE to the TODO list (resend with subject)
Список pgsql-hackers
> What does the MERGE command do?  I have never heard of it, so I doubt
> someone is working on it.

It is basically the SQL standard version of MySQL's REPLACE syntax.  It 
does an update-else-insert set.  However, the trick is that it uses some 
sort of next key locking to ensure that it cannot fail.  Something that 
is impossible to do in PostgreSQL at the moment. Nested transactions 
will help, however.

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Comments on all system objects
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Adding MERGE to the TODO list (resend with subject)