Re: [sqlite] record order in select

2009-04-24 Thread Eric Minbiole
> If "order by" isn't used in a select statment, does the result records > ordered in rowid? If you omit an ORDER BY clause, the order of the resulting data is undefined. It might happen to be ordered by rowid in some cases, but this is not guaranteed. (Might change in a future version,

Re: [sqlite] record order in select

2009-04-24 Thread Igor Tandetnik
"Wenton Thomas" wrote in message news:790786.83985...@web111003.mail.gq1.yahoo.com > If "order by" isn't used in a select statment, does the result > records ordered in rowid? Generally, no. It could accidentally happen this way, but there's no guarantee. If you want a particular order (by

[sqlite] record order in select

2009-04-24 Thread Wenton Thomas
If "order by" isn't used in a select statment, does the result records ordered in rowid? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users