Postgres Pro
Downloads
Home   >   mailing lists

Per row status during INSERT .. ON CONFLICT UPDATE? - Mailing list pgsql-hackers

From Robins Tharakan
Subject Per row status during INSERT .. ON CONFLICT UPDATE?
Date
Msg-id CAEP4nAwCXk2+YvxgsULbwaT1Qzmcs1A1eYJr98cBv-=3Xm3tTA@mail.gmail.com
Whole thread Raw
Responses Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Thom Brown <thom@linux.com>)
Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view
Hi,

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 ?

The RETURNING clause just allows us to return columns, but am unable to find a way to know 'what' happened to a given row.

​Any pointers would be helpful.
Couldn't find anything related in 9.5devel docs either.​

--
thanks
​
Robins

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: upper planner path-ification
Next
From: Amit Kapila
Date:
Subject: Re: Parallel Seq Scan