Received: from mta2-rme.xtra.co.nz (mta2-rme.xtra.co.nz [203.96.92.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1J4jSx99589 for ; Sun, 18 Feb 2001 23:45:29 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.55.85.216]) by mta2-rme.xtra.co.nz with SMTP id <20010219044514.JKTK14925109.mta2-rme.xtra.co.nz@berty> for ; Mon, 19 Feb 2001 17:45:14 +1300 Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Organization: At Home To: pgsql-sql@postgresql.org Subject: Bug? Me or PostgreSQL. Date: Mon, 19 Feb 2001 17:45:03 +1300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01021917450300.27125@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/301 X-Sequence-Number: 1497 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 <<--