Re: Could be improved point of UPSERT - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Could be improved point of UPSERT
Date
Msg-id CAM3SWZR+5xmsbQAL9F3AxCDtCmuAGOqev9a1ouaBUEyPAe6SDA@mail.gmail.com
Whole thread Raw
In response to Re: Could be improved point of UPSERT  (Gianni <nasus.maximos@gmail.com>)
List pgsql-hackers
On Tue, Jul 14, 2015 at 11:40 AM, Gianni <nasus.maximos@gmail.com> wrote:
> Could there be a version of UPSERT where an update is tried, and if 0 records
> are modified, an insert is done?
>
> Just wondering, I haven't got am use-case for that.  I don't mid gaps in
> sequences.

Perhaps, if you don't mind having a severely restricted set of
qualifications in the UPDATE, which the existing command effectively
has anyway. That would be a very odd thing.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: David Guimaraes
Date:
Subject: Re: Forensic recovery deleted pgdump custom format file
Next
From: Alvaro Herrera
Date:
Subject: Re: ctidscan as an example of custom-scan (Re: [v9.5] Custom Plan API)