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