Re: INSERT ... ON CONFLICT syntax issues - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: INSERT ... ON CONFLICT syntax issues
Date
Msg-id CAM3SWZR+Z-7WjXWGW_if08dRqF2QwaL+oRC_AM-pa2ofj67KWA@mail.gmail.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT syntax issues  (Andres Freund <andres@anarazel.de>)
Responses Re: INSERT ... ON CONFLICT syntax issues
List pgsql-hackers
On Tue, Apr 28, 2015 at 7:38 AM, Andres Freund <andres@anarazel.de> wrote:
> On 2015-04-28 16:36:28 +0200, Petr Jelinek wrote:
>> I am also very sure that every time I'll write this statement I will have to
>> look into manual for the names of TARGET and EXCLUDED because they don't
>> seem intuitive to me at all (especially the EXCLUDED).
>
> Same here. I don't understand why 'CONFLICTING' would be more ambiguous
> than EXCLUDED (as Peter argued earlier). Especially given that the whole
> syntax is called ON CONFLICT.

Because the TARGET and EXCLUDED tuples conflict with each other -
they're both conflicting.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: WIP: multivariate statistics / proof of concept
Next
From: Stephen Frost
Date:
Subject: Re: INSERT ... ON CONFLICT syntax issues