On 7/9/18, R Smith <ryansmit...@gmail.com> wrote: > a - Does it affect the UPSERT statement's ON CONFLICT clause? i.e. does > INSERT.... ON CONFLICT... trigger the conflict resolution when the > CHECK fails?
No UPSERT only works for uniqueness constraints (UNIQUE or PRIMARY KEY). > b - If so, would it be real hard to make it so for column ... CHECK(...) > ON CONFLICT... too? > We follow the lead of PostgreSQL. If you can convince the PostgreSQL devs to support upsert on check constraints, we will consider it. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users