Re: someone working to add merge? - Mailing list pgsql-hackers

From John Hansen
Subject Re: someone working to add merge?
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE50A93B0@rodrick.geeknet.com.au
Whole thread Raw
In response to someone working to add merge?  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-hackers
I Wrote:

> From the mysql manual:
>
> 'REPLACE works exactly like INSERT, except that if an old
> record in the table has the same value as a new record for a
> PRIMARY KEY or a UNIQUE index, the old record is deleted
> before the new record is inserted. See Section 13.2.4,
> "INSERT Syntax".'

It also says:
Note that unless the table has a PRIMARY KEY  or UNIQUE index, using a
REPLACE statement makes no sense. It becomes equivalent to INSERT,
because there is no index to be used to determine whether a new row
duplicates another.


... John


pgsql-hackers by date:

Previous
From: "John Hansen"
Date:
Subject: Re: someone working to add merge?
Next
From: Jaime Casanova
Date:
Subject: Re: MERGE vs REPLACE