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
Andrew Gierth and...@tao11.riddles.org.uk writes:
For bonus weirdness:
select distinct random(),random() from generate_series(1,10);
set enable_hashagg=off;
select distinct random(),random() from generate_series(1,10);
I think _that_ one is a bug.
Hmm. I think the first one is a bug ---
Tom == Tom Lane t...@sss.pgh.pa.us writes:
For bonus weirdness:
select distinct random(),random() from generate_series(1,10);
set enable_hashagg=off;
select distinct random(),random() from generate_series(1,10);
I think _that_ one is a bug.
Tom Hmm. I think the first one is a bug
Andrew Gierth and...@tao11.riddles.org.uk writes:
If you try it using nextval(), you'll notice that the function does
in fact get called twice per row, but one of the results is thrown
away and replaced with the other one.
Yeah. The problem is that setrefs.c is generating a tlist for the
Ron Mayer rm...@cheapcomplexdevices.com writes:
[1] http://archives.postgresql.org/pgsql-general/2006-11/msg01544.php
FWIW, the behavior has changed from the time of that discussion ---
we now track sort ordering using EquivalenceClasses, which are able
to distinguish different instances of
Tom == Tom Lane t...@sss.pgh.pa.us writes:
Tom Ron Mayer rm...@cheapcomplexdevices.com writes:
[1] http://archives.postgresql.org/pgsql-general/2006-11/msg01544.php
Tom FWIW, the behavior has changed from the time of that discussion ---
Tom we now track sort ordering using
This query:
select random() from generate_series(1,10) order by random();
produces sorted output. Should it?
--
Andrew (irc:RhodiumToad)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Andrew Gierth and...@tao11.riddles.org.uk writes:
This query:
select random() from generate_series(1,10) order by random();
produces sorted output.
Should it?
It always has; we'd doubtless break some apps if we changed that.
regards, tom lane
--
Sent via
Tom == Tom Lane t...@sss.pgh.pa.us writes:
This query:
select random() from generate_series(1,10) order by random();
produces sorted output.
Should it?
Tom It always has; we'd doubtless break some apps if we changed that.
For bonus weirdness:
select distinct random(),random() from
