From: | "Dale Johnson" <djohnson(at)mi(dot)ab(dot)ca> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | REPLACE INTO table a la mySQL |
Date: | 2001-06-04 03:15:03 |
Message-ID: | X2DS6.60198$%i7.46338814@news1.rdc1.sfba.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I know we're not in the business of copying mySQL,
but the REPLACE INTO table (...) values (...) could be
a useful semantic. This is a combination INSERT or
UPDATE statement. For one thing, it is atomic, and
easier to work with at the application level. Also
if the application doesn't care about previous values,
then execution has fewer locking issues and race
conditions.
comments?
Dale Johnson
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-04 14:25:02 | Re: Australian timezone configure option |
Previous Message | Teodor | 2001-06-03 19:03:26 | Re: Re: Full text searching, anyone interested? |