Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Date
Msg-id CAM3SWZQ-mD6FWAXBEVD_HOanSPpaLrz58PJwARB8zFG70b6mQQ@mail.gmail.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-hackers
On Sun, Sep 28, 2014 at 3:41 PM, Gavin Flower
<GavinFlower@archidevsys.co.nz> wrote:
> How about have a stub page for MERGE, saying it is not implemented yet, but
> how about considering UPSERT - or something of that nature?
>
> I can suspect that people are much more likely to look for 'MERGE' in an
> index, or look for 'MERGE' in the list of SQL commands, than 'UPSERT'.

Seems reasonable.

What I have a problem with is using the MERGE syntax to match people's
preexisting confused ideas about what MERGE does. If we do that, it'll
definitely bite us when we go to make what we'd be calling MERGE do
what MERGE is actually supposed to do. I favor clearly explaining
that.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Next
From: Gregory Smith
Date:
Subject: Re: Time measurement format - more human readable