David Newall <davidn-postgres (AT) rebel (DOT) net.au> writes:
Hmph. Evidently the planner should refuse to flatten subselects that
have volatile functions in their output list (and perhaps anywhere
else??). This will probably make some people unhappy, but I see no
other fix.

I assume though that this is a made-up example and is not the case
that's really troubling you. What is the actual problem you are looking
at?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:
I was generating random test data and naively assumed that ()::integer
truncated its value, therefore I was getting duplicate values. Once I
I realised that random()::integer was rounded I had no further problem,
but figured should report the bug that I had already noticed.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings