distinguish update from insert (on conflict)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: distinguish update from insert (on conflict)
Date: 2019-05-22 01:34:28
Message-ID: 20190522013428.GG4426@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Justin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-22 01:57:36 Re: distinguish update from insert (on conflict)
Previous Message Will Hartung 2019-05-21 23:26:20 Re: Loading table with indexed jsonb field is stalling