Search Postgresql Archives

Re: distinguish update from insert (on conflict)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/21/19 6:34 PM, Justin Pryzby wrote:
Is it still impossible to distinguish whether a row was inserted vs updated ?

You will need to be more specific.

On a hunch, see transition relation info here:
https://www.postgresql.org/docs/10/sql-createtrigger.html


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





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux