>>>>> "Tom" == Tom Lane <tgl@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 generate_series(1,10);
set enable_hashagg=off;
select distinct random(),random() from generate_series(1,10);
I think _that_ one is a bug.
--
Andrew (irc:RhodiumToad)