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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-30 23:43:34 | Re: Math Huh? |
Previous Message | Josh Berkus | 2002-05-30 23:29:26 | Math Huh? |