> Behalf Of Richard Hipp > > And also the meaning/use of > SQLITE_INDEX_CONSTRAINT_FUNCTION, that would be ... > The SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism was added to support > the new Geopoly extension, and the ability to index on things like > "WHERE geopoly_within(_shape,...)" and "WHERE > geopoly_overlap(_shape,...)". There is little to no documentation on > the SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism yet. See the geopoly > implementation for an example. > -- > D. Richard Hipp
Thanks for the scoop! OK, at this point I'll assume the 'NOT' variant of MATCH, LIKE, GLOB, REGEXP are currently /not/ supported in xBestIndex, and just hope that maybe someday they will be. Cheers, and thanks for all the feedback! -dave _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users