Re: MERGE vs REPLACE

Поиск
Список
Период
Сортировка
От Gregory Maxwell
Тема Re: MERGE vs REPLACE
Дата
Msg-id e692861c0511130701h4c312746l732554f73be5c2ef@mail.gmail.com
обсуждение исходный текст
Ответ на Re: MERGE vs REPLACE  (Robert Treat <xzilla@users.sourceforge.net>)
Ответы Re: MERGE vs REPLACE  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-hackers
On 11/13/05, Robert Treat <xzilla@users.sourceforge.net> wrote:
> On Saturday 12 November 2005 04:06, Matteo Beccati wrote:
> > | 1 |    1 | NULL |
> Wow, that seems ugly.... maybe there's a reason for it, but I'm not sure we
> could deviate from my$ql's behavior on this even if we wanted... they are the
> "standard" here.

I don't think that's ugly, I think that's exactly working as
advertised. Replace behaves exactly like deleting the record with the
matching primary key and inserting the provided input. ... not merging
together old data with new.


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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: MERGE vs REPLACE
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: SIGSEGV taken on 8.1 during dump/reload