Igor Tandetnik wrote: > c.panel <[EMAIL PROTECTED]> wrote: > >>no possibilities for indexing on an expression : is it a >>particularity of SQL or SQLite ? > > > Personally, I never saw any DBMS that supported anything like this. I > can't prove that none such exists, of course. > > Igor Tandetnik > I have seen such indices. The key is evaluated at the time the record is inserted and an index built. The poster could use a trigger with an update to place the evaluated expression into a colum. > > > _______________________________________________ > 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