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(at)agliodbs(dot)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(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