On May 27 11:50, Tom Lane wrote:
> Volkan YAZICI <[EMAIL PROTECTED]> writes:
> > ISTM, there's a problem in the correlation of random() to outer JOINs.
>
> The random() functions are being evaluated more than once because the
> subselect gets "flattened" into the outer query, so that you have
> th
Volkan YAZICI <[EMAIL PROTECTED]> writes:
> ISTM, there's a problem in the correlation of random() to outer JOINs.
The random() functions are being evaluated more than once because the
subselect gets "flattened" into the outer query, so that you have
the equivalent of
select random(), ...
