On Wed, Sep 3, 2014 at 2:52 PM, Richard Hipp <d...@sqlite.org> wrote:
> SQLite does not (yet) support indexes on expressions. This begs the question: Are there plans, possibly ongoing, to add this support? Any timeframe? Asked differently, if adding this support, could this be done by adding virtual / computed columns to tables, and indexing those columns? You can emulate virtual columns with views of course, but then you have a table and view, necessarily named differently, and of course you cannot index views, while some DBMS allow indexing virtual / computed columns. --DD Fantasy SQL: create table t (id number primary key, c1, c2, ... ); alter table t add column c99 as (c1 + c2); create index idx_t_c99 on t.c99; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
