Re: Replaceing records - Mailing list pgsql-general

From Jonathan Bartlett
Subject Re: Replaceing records
Date
Msg-id Pine.GSU.4.44.0309041006140.4262-100000@eskimo.com
Whole thread Raw
In response to Re: Replaceing records  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
I think this would be very useful.

Jon

On 4 Sep 2003, Greg Stark wrote:

>
> Harald Fuchs <nospam@sap.com> writes:
>
> > You can't.  The only thing MySQL has to offer is
>
> Actually I found two things related to this:
>
> http://www.mysql.com/doc/en/INSERT.html
>
> http://www.mysql.com/doc/en/REPLACE.html
>
> You can do
>  INSERT INTO tab (...) VALUES (...) ON DUPLICATE KEY UPDATE col=val, ...
>
> It seems to be newer than REPLACE.
>
> In any case, both seem doable in postgres since in its MVCC every update is a
> delete+insert anyways. It means doing the delete if necessary and doing the
> insert unconditionally.
>
> But I'm not sure how convinced the developers are of its usefulness beyond
> satisfying mysql migrations. I've never used mysql and I have seen a few times
> it might have been useful. Not a lot, but a few. And it seems to be a frequent
> question on the mailing list.
>
> --
> greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


pgsql-general by date:

Previous
From: Diogo Biazus
Date:
Subject: Re: French translation
Next
From: Alvaro Herrera Munoz
Date:
Subject: Re: French translation