Yea, of course in the real world you'd never use it that way, I've seen people baffled why the result set is returned out of order when they didn't specify an order. If there are multiple people using a database, sometimes the database may be in the middle of returning a resultset that is similar enough to yours, that it will stream the result set to you when it was ordered for the other person by a different column, especially when you don't specify an order by clause. So, when you don't specify an order clause, you'll get results in any order. Never assume that the database is going to return data the way it is on disk, or in the order it was written unless you specifically request an order. It will do whatever is most efficient, and that result set can change from one query to the next.
On Sunday, May 26, 2013 3:56:31 PM UTC-7, Simon Ashley wrote: > > Thanks, that's good to know ... -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.