On 8/12/20 7:23 AM, pinker wrote:
> is there any way to distinct between updated and inserted rows in RETURNING
> clause when ON CONFLICT UPDATE was used?
Do you want to use that information immediately in the query or store it
somewhere? If the first case I don't think that is possible. For the
second then, I haven't tried it but, maybe a trigger using transition
tables per example here:
https://www.postgresql.org/docs/12/plpgsql-trigger.html
Example 42.7. Auditing with Transition Tables
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com