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