Bug? Me or PostgreSQL.

From: Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Bug? Me or PostgreSQL.
Date: 2001-02-19 04:45:03
Message-ID: 01021917450300.27125@berty
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
<<--

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-19 05:37:01 Re: Bug? Me or PostgreSQL.
Previous Message Tatsuo Ishii 2001-02-19 01:44:43 Re: [SQL] PL/SQL-to-PL/PgSQL-HOWTO beta Available