On Mon, Feb 25, 2008 at 7:13 AM, Roland Romvary <[EMAIL PROTECTED]> wrote: > Can I take it for sure that the order of the rows returned by 2 queries are > the same? > The only difference between the queries is that the selected columns of the > first query are subset of the second.
No, the SQL standard is very explicit about that. The only way to be sure is by using an "ORDER BY" clause, but you can use "ORDER BY rowid" if you really want to sort by the internal b-tree index (but you need to know what you are doing). Regards, ~Nuno Lucas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users