* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2007-01-20 23:55]: > > I believe that the SQL spec doesn't specify the order of > > returned rows if you don't specify an order. > > SQL doesn't, but SQLite might. Without maintaining order OFFSET > (also not part SQL standart) without ORDER BY wouln't make much > sense.
Well in fact it doesn’t. If you use LIMIT/OFFSET without an explicit ORDER BY, you are relying on an implementation detail. If I’m not mistaken, ordering by row ID does not incur any overhead to speak of, so there’s never a good reason to omit the ORDER BY clause. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
