[SQL] Bug? Me or PostgreSQL.

[Christopher Sawtell]

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 
<<--