On 2015-05-19 17:53:09 +0530, Robins Tharakan wrote: > Is there a way to know which rows were INSERTed and UPDATEd when doing a > INSERT ... ON CONFLICT UPDATE? Probably via pseudo column indicating INSERT > / UPDATE ?
No, not really. > The RETURNING clause just allows us to return columns, but am unable to > find a way to know 'what' happened to a given row. There previously has been discussion about extending RETURNING to allow to return the before/after row. But to me that's a mostly independent feature to ON CONFLICT. Greetings, Andres Freund -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers