Re: More than one UNIQUE key when matching items..

On Sat, 2021-03-20 at 15:51 +0000, Ron Clarke wrote:
> In SQL Server this is easy, we insert the records into a temporary table with separate Unique
>  indexes on the id for set a and the ids for set b and put the 'ignore_dup_key' on which tells
>  SQL Server to ignore duplicate rows and carry on.
> 
> The nearest to this at first appears to be the ON CONFLICT ON CONSTRAINT IGNORE in Postgres.
>  But this only works with a single constraint, at a time i.e. we can't set the ON CONFLICT ON
>  CONSTRAINT IGNORE to work with multiple UNIQUE indexes.

You can try this:

INSERT ... ON CONFLICT DO NOTHING;

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com