Re: Math Huh?

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