>
> Are you sure this is true? The rowid in the source table has no
> relationship to the order of the results of the query.
You're right. I thought it was the row number of the result set, it's not:
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table t1(
...> Id INTEGER PRIMARY KEY,
...> value text );
sqlite> insert into t1(value) values('one');
sqlite> insert into t1(value) values('two');
sqlite> insert into t1(value) values('three');
sqlite> insert into t1(value) values('four');
sqlite> select * from t1;
1|one
2|two
3|three
4|four
sqlite> select rowid, value from t1 where id>2;
3|three
4|four
sqlite>
Dave, Looks like rowid gives you the order of insertion not the order
of retrieval.
