| 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: | Whole Thread | Raw Message | 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
<<--
| 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 |