Semi-OT: GETNEXT methodology in SQL?
Fairlight
fairlite at fairlite.com
Wed Jun 10 12:33:06 PDT 2009
This public service announcement was brought to you by Walter Vaughan:
>
> One thing to remember is that you should expect a SQL database to return
> rows in a random order each time you query unless you use the "order by"
> clause.
Of that, I'm acutely aware. :/ I've seen that in my own tables that have
unique ID's. It seemed to act kind of like fP's freechain at first, but
past a point it did seem to be truly pseudo-random. It's consistent, but
there's no apparent reason for the ordering when unspecified.
mark->
--
"I'm not subtle. I'm not pretty, and I'll piss off a lot of people along
the way. But I'll get the job done" --Captain Matthew Gideon, "Crusade"
More information about the Filepro-list
mailing list