Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Gregory Maxwell
Subject Re: MERGE vs REPLACE
Date
Msg-id e692861c0511130701h4c312746l732554f73be5c2ef@mail.gmail.com
Whole thread Raw
In response to Re: MERGE vs REPLACE  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: MERGE vs REPLACE
List 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 by date:

Previous
From: Robert Treat
Date:
Subject: Re: MERGE vs REPLACE
Next
From: Martijn van Oosterhout
Date:
Subject: Re: SIGSEGV taken on 8.1 during dump/reload