Hi everyone, What's the status of `ON CONFLICT` st...
# room
m
Hi everyone, What's the status of
ON CONFLICT
statement in room?
Copy code
INSERT INTO X (a,b,c) VALUES (:x, :y, :z)
ON CONFLICT(X) DO UPDATE SET
a=excluded.a
WHERE excluded.b > X.b
works, but using multiple
ON CONFLICT
results in error. The "spec" suggests you can have multiple
ON CONFLICT
in the statement and it works in sqlite3 command line