Re: multiple conflict targets

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