On 19 Oct 2018, at 5:24pm, David Raymond <[email protected]> wrote:
> sqlite> insert into ids (id, in_new) select distinct id, 1 from gc_new on > conflict (id) do update set in_new = 1; You can't supply a statement for ON CONFLICT. It can only trigger IGNORE / FAIL / ABORT / ROLLBACK / REPLACE. <https://sqlite.org/lang_conflict.html> If you need anything more sophisticated, you might like to make a TRIGGER. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
