Re: Bug? Me or PostgreSQL.

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