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

From John Hansen
Subject Re: someone working to add merge?
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE50A93B1@rodrick.geeknet.com.au
Whole thread Raw
In response to someone working to add merge?  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-hackers
Jaime Casanova Wrote:
> But MERGE isn't REPLACE...
>
> REPLACE will delete old records to insert new ones; MERGE try
> to insert and if the record exists then can UPDATE just a few
> values, maybe incrementing them with a value (all the
> calculation are doing by the MERGE)

That sounds like MySQL's 'INSERT INTO ... ON DUPLICATE KEY UPDATE',
which they recommend over REPLACE anyways.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: someone working to add merge?
Next
From: Tom Lane
Date:
Subject: Re: Multi-table-unique-constraint