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
sqlite-users mailing list

Reply via email to