| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Math Huh? |
| Date: | 2002-05-31 06:36:53 |
| Message-ID: | Pine.LNX.4.44.0205310935330.26009-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 30 May 2002, Josh Berkus wrote:
> Folks,
>
> I'll let this session speak for itself:
>
> jwnet=> select version();
> version
> ---------------------------------------------------------------
> PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3
> (1 row)
>
> jwnet=> select (255 * 255 * 255 * 255);
> ?column?
> -----------
> -66716671
> (1 row)
>
> So, a bug, or what?
Dear Josh, i686-pc-linux-gnu
^^^
the 686 arch is the answer.
dynacom=# select (255::int8 * 255 * 255 * 255);
?column?
------------
4228250625
(1 row)
dynacom=#
>
>
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2002-05-31 08:18:00 | contrib/intarray |
| Previous Message | Sandeep Chibber | 2002-05-31 05:22:08 | Postgres Function Call Problem |