On 6/20/18, Jonathan Koren <jdko...@gmail.com> wrote: > > The grammar & documentation > <https://www.sqlite.org/draft/lang_UPSERT.html> shows > a WHERE clause can be given in the "conflict target" of the UPSERT, but the > documentation does not explain how the result of this clause impacts the > statement. As a test, I tried the following:
The WHERE clause on the conflict-target is only used for partial indexes. -- 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
