SQLite does not (yet) support indexes on expressions.
On Tue, Sep 2, 2014 at 9:06 PM, Philippe Riand <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
