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

From Christopher Sawtell
Subject Bug? Me or PostgreSQL.
Date
Msg-id 01021917450300.27125@berty
Whole thread Raw
Responses Re: Bug? Me or PostgreSQL.
Re: Bug? Me or PostgreSQL.
List pgsql-sql
Greetings,

How can this happen?

chris=# select name from boys_names where 
boys_names.number=(random()*225+1)::int4; name
--------FredGunnarManuelRainer
(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,
compiledby GCC egcs-2.91.66
 
(1 row)

-- 
Sincerely etc.,
NAME       Christopher SawtellCELL PHONE 021 257 4451ICQ UIN    45863470EMAIL      csawtell @ xtra . co . nzCNOTES
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 
<<--



pgsql-sql by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: PL/SQL-to-PL/PgSQL-HOWTO beta Available
Next
From: Tom Lane
Date:
Subject: Re: Bug? Me or PostgreSQL.