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