Re: Improper processing of random values in sub-queries - Mailing list pgsql-bugs

From davidn-postgres@rebel.net.au
Subject Re: Improper processing of random values in sub-queries
Date
Msg-id Pine.LNX.4.58.0407101332450.12278@localhost.localdomain
Whole thread Raw
In response to Re: Improper processing of random values in sub-queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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?

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.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SELECT DISTINCT on boxes
Next
From: davidn-postgres@rebel.net.au
Date:
Subject: Re: Can't join on null values