On Tue Nov 01, 2016 at 10:19:24PM -0400, Richard Hipp wrote: > On 11/1/16, Mark Lawrence <no...@null.net> wrote: > > Hello all, > > > > The documentation for partial indexes (section 3.2) lists "=, <, >, <=, > > >=, <>, or IN" as operators that will trigger the use of an > > index WHERE c IS NOT NULL. > > > > It seems to me that LIKE should also be in that list, given that it > > will also only match when c is not null. > > LIKE and GLOB are added by check-in > https://www.sqlite.org/src/info/9b3a3b41b59a7ce7
Thanks for that. I don't know if the draft website is in the same repository (or how often it gets updated) but I don't see a matching change to the documentation in this patch... -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
