On 9 October 2014 07:27, Peter Geoghegan <p...@heroku.com> wrote: > Please be more specific.
Do not use CONFLICTING() which looks like it is a function. Instead, use a row qualifier, such as NEW, OLD etc to reference values from the incoming data e.g. CONFLICTING.value rather than CONFLICTING(value) Do not use the word CONFLICTING since it isn't clear whether you are referring to the row in the table or the value in the incoming data. I suggest the use of two separately named row qualifiers to allow us to use either of those when desired. I don't have suggestions as to what you should call those qualifiers, though Postgres already uses NEW and OLD in similar circumstances in triggers. (This has nothing at all to do with the MERGE command in the SQL standard, so please don't mention that here.) You may also wish to support the AS keyword, as MERGE does to make the above even more clear. e.g. SET col = EXISTING.col + NEW.col Thank you. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers