On 7/9/18, R Smith <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
