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