Per row status during INSERT .. ON CONFLICT UPDATE?

Поиск
Список
Период
Сортировка
От Robins Tharakan
Тема Per row status during INSERT .. ON CONFLICT UPDATE?
Дата
Msg-id CAEP4nAwCXk2+YvxgsULbwaT1Qzmcs1A1eYJr98cBv-=3Xm3tTA@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: upper planner path-ification
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Parallel Seq Scan