Re: Math Huh? - Mailing list pgsql-sql

Josh Berkus <josh@agliodbs.com> writes:
> jwnet=> select (255 * 255 * 255 * 255);
>  ?column?
> -----------
>  -66716671
> (1 row)

> So, a bug, or what?

(yawn) int4 overflow.  Use float or numeric if you want overflow
robustness...
        regards, tom lane