On 08/10/2018 03:12 AM, Torsten Förtsch wrote:
> Hi,
>
> if I read https://www.postgresql.org/docs/9.6/static/sql-insert.html
> correctly there can be only one conflict target or none at all.
>
> What if I have a table with 3 unique constraints? If the first one is
> violated by the insert I want to do nothing. If the 2nd is violated some
> fields should be updated. And violation of the 3rd one should raise an
> error.
>
> Can that be expressed?
Yes as a trigger and associated function.
>
> Thanks,
> Torsten
--
Adrian Klaver
adrian.klaver@aklaver.com