Re: Bug? Me or PostgreSQL. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Bug? Me or PostgreSQL.
Date
Msg-id 21084.982561021@sss.pgh.pa.us
Whole thread Raw
In response to Bug? Me or PostgreSQL.  (Christopher Sawtell <csawtell@xtra.co.nz>)
List pgsql-sql
Christopher Sawtell <csawtell@xtra.co.nz> writes:
> How can this happen?

> chris=# select name from boys_names where 
> boys_names.number=(random()*225+1)::int4;
>   name
> --------
>  Fred
>  Gunnar
>  Manuel
>  Rainer
> (4 rows)

Er, what's your complaint exactly?  It's not obvious to me that
there's anything wrong here.  You seem to have gotten random
matches on four rows --- if that's ridiculously too low (or too
high) you'd better explain why you think so.
        regards, tom lane


pgsql-sql by date:

Previous
From: Christopher Sawtell
Date:
Subject: Bug? Me or PostgreSQL.
Next
From: Tod McQuillin
Date:
Subject: Re: Bug? Me or PostgreSQL.