>>>>> "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 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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers