On Sunday, January 21, 2007, 11:39:47 AM, [EMAIL PROTECTED]<[email protected]> wrote: >> If you use LIMIT/OFFSET without an >> explicit ORDER BY, you are relying on an implementation detail.
> Yes, but SQLite is an implementation. If it returns rows allways in the same > order I don't see why it shouldn't be acknowledged - one mention in a > documentation would make it a feature, and I think quite usefull one. > ---------------------------------------------------------------------- > Nawet 50MB w jednym liscie>>> http://link.interia.pl/f19e7 > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- Got one question: doesn't it return in the order of storage in the file, rather than the insert order. Because as we know, it fills empty spaces left by deletes with new rows if they fit. And by the way - Yes, SQLite is an implementation but if they change this in newer version without acknowledging us (because it's undocumented feature) you can just find yourself in a very awkward situation... ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
