On 1/19/07, Kevin Dangoor <[EMAIL PROTECTED]> wrote:
What I'm wondering about is whether I should put an integer primary key on the data table to ensure that the ordering is correct, or if "SELECT * FROM <table> LIMIT <x> OFFSET <y>" will reliably return data in the same order in which is was inserted. It seems to, but I'd rather not take that for granted...
Without an ORDER BY, there is no guarantee what order the data will be returned. That would be true even if you put an INTEGER PRIMARY KEY on the table. Unless, of course, you ORDER BY the key. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
