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

Reply via email to