On 2016-09-08 12:17, Paul Sanderson wrote: > How does this work for you to get all the even rows > > SELECT ROWID > FROM table > WHERE ROWID & 0x01 = 0x00
I think you should be able to create an expression index as well: https://www.sqlite.org/lang_createtable.html#rowid - Matthias-Christian _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
