Re: Improper processing of random values in sub-queries

From: davidn-postgres(at)rebel(dot)net(dot)au
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Improper processing of random values in sub-queries
Date: 2004-07-10 04:22:21
Message-ID: Pine.LNX.4.58.0407101332450.12278@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message davidn-postgres 2004-07-10 04:40:36 Re: Can't join on null values
Previous Message Tom Lane 2004-07-10 03:58:27 Re: Fwd: postgresql-autodoc - missinterprets "version"