Thanks for bringing that up. I do use an ORDER BY but for some reason
forgot to mention it.
On Thursday, December 26, 2002, at 12:42 PM, Tim Roberts wrote:
> If you will allow me to slide into SQL pedantics for a moment, you
> always use an ORDER BY clause when using LIMIT and OFFSET like that.
> that SQL records are, by definition, unordered. Without an ORDER BY
> there is no guarantee that the record order will be the same from
> query to
> query, so you could get unexpected gaps and repeats when fetching by
> pages like
> Now, in practical terms, Postgres and MySQL all DO have an internal
> so unless there are deletions and insertions in the interim, this
> isn't a real
> concern, but since the standard allows it, someday there will be an
> implementation that takes advantage of it. Forewarned is forearmed.