On Thu, 23 May 2013 18:38:57 -0600
"Keith Medcalf" <kmedc...@dessus.com> wrote:
> > And, can I depend on SQLite to generate results in the same order
> > as the original prepare/step sequence and the temp table
> > generation, ie. is the temp table's rowid going to be consistent
> > with the original step order?
>
> If you use an ORDER BY clause, yes. If not, then the rows are
> returned in random order.
Pardon me while I fix that for you.
s/random/nondeterministic/
but for the purposes of discussion much the same: without ORDER BY, the
order cannot be relied on.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
