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

From Peter Geoghegan
Subject Re: Per row status during INSERT .. ON CONFLICT UPDATE?
Date
Msg-id CAM3SWZRBdCkP5Dm8-5mTd3axRx=XWUDVT8WmgA2KB3-ZcoKK7w@mail.gmail.com
Whole thread Raw
In response to Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Andres Freund <andres@anarazel.de>)
Responses Re: Per row status during INSERT .. ON CONFLICT UPDATE?  (Robins Tharakan <tharakan@gmail.com>)
List pgsql-hackers
On Tue, May 19, 2015 at 10:49 AM, Andres Freund <andres@anarazel.de> wrote:
>> 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.

That's certainly something we talked about. It could probably be done
with some kind of magical expression. I have to wonder how many of the
people that are sure that they need this really do, though. Is it
really natural to care about this distinction with idiomatic usage?

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Per row status during INSERT .. ON CONFLICT UPDATE?
Next
From: Peter Geoghegan
Date:
Subject: Re: a few thoughts on the schedule