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
