Re: Math Huh? - Mailing list pgsql-sql

From Larry Rosenman
Subject Re: Math Huh?
Date
Msg-id 1022805419.356.0.camel@lerlaptop
Whole thread Raw
In response to Re: Math Huh?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
On Thu, 2002-05-30 at 18:59, Josh Berkus wrote:
> 
> Tom,
> 
> > (yawn) int4 overflow.  Use float or numeric if you want overflow
> > robustness...
> 
> Shouldn't it give me an error?  This does:
> 
> SELECT (255^4)::INT4
Why?  You're doing 3 multiplications, instead of one power.  It has no
idea what the number is. 


> 
> 
> -- 
> -Josh Berkus
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                         Josh Berkus
>    Complete information technology     josh@agliodbs.com
>     and data management solutions     (415) 565-7293
>    for law firms, small businesses      fax 621-2533
>     and non-profit organizations.     San Francisco
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Math Huh?
Next
From: Achilleus Mantzios
Date:
Subject: Re: Math Huh?