On 19 Oct 2018, at 5:24pm, David Raymond <david.raym...@tomtom.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users