On Thu, Aug 28, 2014 at 7:29 AM, Andreas Karlsson <andr...@proxel.se> wrote: > Personally I would find it surprising if RETURNING did not also return the > updated tuples. In many use cases for upsert the user does not care if the > row was new or not.
I'm not attached to that particular behavior, but it does seem kind of similar to the behavior of BEFORE triggers, where a NULL return value ("do nothing") will also cause RETURNING to not project the tuple. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers