On 26 Jul 2011, at 6:13pm, Black, Michael (IS) wrote: > Part of the problem is it seems you can't create an index with rowid: > > > > 3.7.5 > > sqlite> create table t(i int); > sqlite> create index idx1 on t(i); > sqlite> create index idx2 on t(i,rowid); > Error: table t has no column named rowid > > > > Any particular reason it can't be included in an index?
Because you didn't define such a column. SQLite handles the various row aliases okay in an expression but not when you DEFINE things. If you declare a column called 'rowid' it'll accept it in a CREATE command, even if it still just maps it to its internal 'id' INTEGER AUTOINCREMENT field. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users