SQLite does not (yet) support indexes on expressions.
On Tue, Sep 2, 2014 at 9:06 PM, Philippe Riand <p...@riand.com> wrote: > Is there a way to create indexes based on expressions instead of simple > columns (see: > http://www.postgresql.org/docs/8.1/static/indexes-expressional.html)? The > idea is to have some custom functions that extract data from a JSON column > and allow a fast query based on an index. This is the strategy used by > POSTGRES and DB2, for example. > I know that we can create a table and do a manual field extraction, but > this is not transparent from a query standpoint, and forces a manual re > computation of all rows when a new index is desired. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
