Dear all,
I have a table with multiple (in this case 2) UNIQUE constraints:
UNIQUE (col1, col2)
UNIQUE (col1, col3, col4, col5)
Is it possible to use UPSERT twice? I have already tried some statements, but
neither of these were successful. This is what I want to achieve:
INSERT INTO ... ON CONFLICT DO UPDATE SET ...
So the update should occur no matter which UNIQUE-constraint would be violated
by the insert.
I've also tried ON CONFLICT (col1, col2, col3, col4, col5) which is rejected
("does not match any UNIQUE constraint"). The error message is perfectly
correct, but doesn't solve my problem ;-)
So what I'm looking for is some kind of "ON CONFLICT (col1, col2) OR CONFLICT
(col1, col3, col4, col5) DO UPDATE".
Any hints for me?
Kind regards,
Thomas
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
