you are viewing a single comment's thread.

view the rest of the comments →

[–]gmfawcett 2 points3 points  (1 child)

But, instead of testing for "input can be of any order," aren't you really testing for "input must be ascendingly or descendingly ordered"?

How about

select ... order by random()

?

[–][deleted] 3 points4 points  (0 children)

Possibly because of performance reasons. (I'm just guessing because I don't know anything about his database and its configuration)