Re: [sqlite] Re: does select reliably return insert order?

2007-01-21 Thread Jay Sprenkle
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

RE: [sqlite] Re: does select reliably return insert order?

2007-01-21 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 21, 2007 2:40 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Re: does select reliably return insert order? > > > > If you use LIMIT/OFFSET without an