mike
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 should
always use an ORDER BY clause when using LIMIT and OFFSET like that. Remember
that SQL records are, by definition, unordered. Without an ORDER BY clause,
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
this.
Now, in practical terms, Postgres and MySQL all DO have an internal ordering,
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.
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
