On 1/21/07, [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.
If you write programs to rely on features that are not guaranteed then you, or the users, will be sorry later. You can learn from other people's mistakes or ignore their good advice. We can't force you to use common sense. -- -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
