Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: MERGE vs REPLACE
Date
Msg-id 4374FA25.1070602@seznam.cz
Whole thread Raw
In response to MERGE vs REPLACE  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> It seems to me that it has always been implicitly assumed around here 
> that the MERGE command would be a substitute for a MySQL-like REPLACE 
> functionality.  After rereading the spec it seems that this is not the 
> case.  MERGE always operates on two different tables, which REPLACE 
> doesn't do.
> 
> That said, what kind of support for insert-or-update-this-row do we want 
> to provide, if any?  Should it be a REPLACE command, an extension of 
> the INSERT command, a modication of the MERGE syntax, or something 
> else?
> 

MERGE of course, it's standard, REPLACE is mysql extension


-- 
Regards
Petr Jelinek (PJMODOS)
www.parba.cz


pgsql-hackers by date:

Previous
From: Matt Newell
Date:
Subject: Re: Multi-table-unique-constraint
Next
From: "Brusser, Michael"
Date:
Subject: How to find a number of connections