On Tue, Jun 20, 2017 at 2:43 AM Simon Slavin <slav...@bigfraud.org> wrote:
> On 20 Jun 2017, at 1:34am, Jens Alfke <j...@mooseyard.com> wrote: > > > You can create indexes to support JSON1 queries by using the same > json_xx function calls in a CREATE INDEX statement. > > That’s a great idea. I don’t know if it works, though. > > This works great, I use it all the time. As long as you use the exact same calculated statement in the index as in the query, the index will be used instead of calculating the value. Wout. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users