Skip site navigation (1) Skip section navigation (2)

Re: Math Huh?

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Math Huh?
Date: 2002-05-30 23:42:52
Message-ID: 1022802174.2593.3.camel@lerlaptop (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, 2002-05-30 at 18:29, 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?
> 
You exceeded a SIGNED int4.. 
ler=# select (255*255*255*255)
ler-# ;
 ?column?  
-----------
 -66716671
(1 row)

ler=# select (255::int8*255::int8*255::int8*255::int8);
  ?column?  
------------
 4228250625
(1 row)

ler=# select version();
                               version                               
---------------------------------------------------------------------
 PostgreSQL 7.2.1 on i386-portbld-freebsd4.6, compiled by GCC 2.95.3
(1 row)

ler=# 



> 
> -- 
> -Josh Berkus
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


In response to

  • Math Huh? at 2002-05-30 23:29:26 from Josh Berkus

pgsql-sql by date

Next:From: Tom LaneDate: 2002-05-30 23:43:34
Subject: Re: Math Huh?
Previous:From: Josh BerkusDate: 2002-05-30 23:29:26
Subject: Math Huh?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group