Bug? Me or PostgreSQL.

Christopher Sawtell <csawtell@xtra.co.nz>

From: Christopher Sawtell <csawtell@xtra.co.nz>
To: pgsql-sql@postgresql.org
Date: 2001-02-19T04:45:03Z
Lists: pgsql-sql
Greetings,

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)

Here is the table declaration:

create table boys_names (
        number                  serial primary key,
        name                    varchar(20)
        ); 

the details of my installation:-

chris=# select version();
                                version
------------------------------------------------------------------------
 PostgreSQL 7.1beta3 on i586-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

-- 
Sincerely etc.,

 NAME       Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -->> Please refrain from using HTML or WORD attachments in e-mails to me 
<<--