Re: Per row status during INSERT .. ON CONFLICT UPDATE?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Per row status during INSERT .. ON CONFLICT UPDATE?
Дата
Msg-id CAM3SWZTKnDgLc9FYTLR+LwJtoJ5F6_GqvWB5EyrbZM_Jm8XwZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Robins Tharakan <tharakan@gmail.com>)
Ответы Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
On Tue, May 19, 2015 at 1:07 PM, Robins Tharakan <tharakan@gmail.com> wrote:
> My use-case is to create an extra row for all UPDATEd rows (only), which is
> implemented in MSSQL by enveloping the MERGE with an INSERT (MERGE ...
> OUTPUT $action) WHERE $action = 'UPDATE'.

That could make sense. You can achieve something similar with per-row
triggers, perhaps.

> Am still to test, but looks like Thom's reply earlier could take care of my
> use-case, so we may need more people requesting this magic field, with a
> valid use-case.

I'm not opposed to it, but it's not a personal priority to implement
this. I don't think it's great practice to use the hidden fields like
that. I can't see anything other than a dedicated expression serving
this purpose, if there is ever a documented solution.

-- 
Peter Geoghegan



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: INSERT ... ON CONFLICT DO UPDATE with _any_ constraint
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Per row status during INSERT .. ON CONFLICT UPDATE?