Re: ORDER BY vs. volatile functions - Mailing list pgsql-hackers

Andrew Gierth <andrew@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 --- the two invocations of
random() in the tlist shouldn't be folded together.
        regards, tom lane