Use a trigger to populate your index column. http://www.sqlite.org/lang_createtrigger.html
On Wed, Sep 3, 2014 at 9:01 AM, Dominique Devienne <ddevie...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users