Horton

Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}

Andreas Karlsson <andreas@proxel.se>

View thread View on postgr.es
From: Andreas Karlsson <andreas@proxel.se>
To: Peter Geoghegan <pg@heroku.com>, Simon Riggs <simon@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>, Craig Ringer <craig@2ndquadrant.com>
Date: 2014-09-28T11:25:09Z
Lists: pgsql-hackers 
On 09/28/2014 09:40 AM, Peter Geoghegan wrote:
>> No explanation of why the CONFLICTING() syntax differs from OLD./NEW.
>> syntax used in triggers
>
> Why should it be the same?

Both can be seen as cases where you refer to a field of a tuple, which 
is usually done with FOO.bar.

-- 
Andreas Karlsson

Commits

  1. Change the way we mark tuples as frozen.

  2. Add documentation for data-modifying statements in WITH clauses.