Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id F08624764CA for ; Fri, 31 May 2002 02:37:57 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id A2D8A476575 for ; Fri, 31 May 2002 02:37:14 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g4V6arx26046; Fri, 31 May 2002 09:36:53 +0300 Date: Fri, 31 May 2002 09:36:53 +0300 (EEST) From: Achilleus Mantzios To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: Math Huh? In-Reply-To: <200205301629.26161.josh@agliodbs.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200205/324 X-Sequence-Number: 7959 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