Hello ! That's awesome !
We can write cleaner queries with this. Thank you so much ! Cheers ! > Sun Sep 06 2015 12:39:03 am CEST CEST from "Richard Hipp" ><drh at sqlite.org> Subject: Re: [sqlite] Second test of json and index >expressions, not so good > > On 9/4/15, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > >>select json_extract(json, '$.value') AS val >> from json_tbl where val = 'the_value_1'; >> > The latest trunk check-in now uses an index for this query > > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
