Re: distinguish update from insert (on conflict) - Mailing list pgsql-general

From Laurenz Albe
Subject Re: distinguish update from insert (on conflict)
Date
Msg-id 54f2f1f00aca3fed9e81b4f370c7e90192bc5062.camel@cybertec.at
Whole thread Raw
In response to distinguish update from insert (on conflict)  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Justin Pryzby wrote:
> Is it still impossible to distinguish whether a row was inserted vs updated ?
> 
> The latest I can see is here:
> https://wiki.postgresql.org/wiki/UPSERT#RETURNING_behavior
> 
> ..but I'm hopeful that the 4 year old wiki page is out of date.

Maybe this answer can help you:

https://stackoverflow.com/a/39204667/6464308

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Centos : Load Average :OS Process Name : migration/1, migration/2, migration/n
Next
From: Thiemo Kellner
Date:
Subject: Table inheritance over schema boundaries possible