Re: Math Huh?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Math Huh?
Date: 2002-05-30 23:43:34
Message-ID: 11059.1022802214@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • Math Huh? at 2002-05-30 23:29:26 from Josh Berkus

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Stanaway 2002-05-30 23:48:47 Re: Math Huh?
Previous Message Larry Rosenman 2002-05-30 23:42:52 Re: Math Huh?