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