Re: Math Huh? - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: Math Huh?
Date
Msg-id Pine.LNX.4.44.0205310935330.26009-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Math Huh?  (Josh Berkus <josh@agliodbs.com>)
List 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@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



pgsql-sql by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Math Huh?
Next
From: Achilleus Mantzios
Date:
Subject: contrib/intarray