On Mon, Mar 14, 2016 at 1:20 PM, Peter Geoghegan <pg@xxxxxxx> wrote: > On Mon, Mar 14, 2016 at 12:28 PM, Peter Devoy <peter@xxxxxxxxx> wrote: >> Is there a reason DO NOTHING was not developed for use with RETURNING? > > I don't know what you mean. It should work fine with RETURNING. He wants to retrieve a value from the conflicting row. Now getting the value that caused the conflict should be easy, because you provided it in the first place. But he wants a value from a different column of the conflicting row than the column(s) on which there is conflict. DO NOTHING RETURNING returns no rows. Which is reasonable, because nothing was inserted. But it isn't what he wants. I think the dummy update is his best bet, but it does seem like there should be a better way. Maybe ON CONFLICT DO SELECT where the select operates over the target row. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
