Re: ORDER BY vs. volatile functions

>>>>> "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)