Re: Syntax of INSERT...ON DUPLICATE KEY LOCK FOR UPDATE - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Syntax of INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Date
Msg-id 52D2BEF3.10900@proxel.se
Whole thread Raw
In response to Syntax of INSERT...ON DUPLICATE KEY LOCK FOR UPDATE  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Syntax of INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
List pgsql-hackers
On 01/11/2014 11:42 PM, Peter Geoghegan wrote:
> I recently suggested that rather than RETURNING REJECTS, we could have
> a REJECTING clause, which would see a DML statement project strictly
> the complement of what RETURNING projects in the same context. So
> perhaps you could also see what RETURNING would not have projected
> because a before row trigger returned NULL (i.e. when a before trigger
> indicates to not proceed with insertion). That is certainly more
> general, and so is perhaps preferable. It's also less verbose, and it
> seems less likely to matter that we'll need to make REJECTING a fully
> reserved keyword, as compared to REJECTS. (RETURNING is already a
> fully reserved keyword not described by the standard, so this makes a
> certain amount of sense to me). If nothing else, REJECTING is more
> terse than RETURNING REJECTS.

I do not entirely understand what you are proposing here.  Any example 
how this would look compared to your RETURNING REJECTS proposal?

-- 
Andreas Karlsson



pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Standalone synchronous master
Next
From: Kevin Grittner
Date:
Subject: ECPG regression tests generating warnings