On Sep 3, 2014, at 3:01 PM, Dominique Devienne <ddevie...@gmail.com> wrote:
> Asked differently, if adding this support, could this be done by adding > virtual / computed columns to tables, and indexing those columns? Ohohohoho… virtual columns [1][2]…. yes… shinny! :) Now that would be rather cool. On the other hand, if one had to choose, I would rather see a MERGE statement, than some funky virtual columns. While virtual columns are handy at time, they are a bit exotic, all things being equal. On the other hand, MERGE is a must have. No amount of creative select + insert + update concoctions can begin to compensate for its absence in SQLite. A huge gap altogether. [1] http://en.wikipedia.org/wiki/Virtual_column [2] http://www.oracle-base.com/articles/11g/virtual-columns-11gr1.php _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users