Andrew Gierth wrote:
> This query:
>
> select random() from generate_series(1,10) order by random();
> produces sorted output. Should it?
I recall a workaround from a different thread[1] if specifically
were looking for random ordering of random numbers is:select random() from foo order by random()+1;
The thread has more odd corner cases with multiple calls
to random() and sorts as well.
[1] http://archives.postgresql.org/pgsql-general/2006-11/msg01544.php