Re: Math Huh? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Math Huh?
Date
Msg-id 200205301659.43775.josh@agliodbs.com
Whole thread Raw
In response to Re: Math Huh?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Math Huh?  (Larry Rosenman <ler@lerctr.org>)
List pgsql-sql
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


--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology     josh@agliodbs.com   and data management solutions     (415) 565-7293  for law firms, small
businesses     fax 621-2533   and non-profit organizations.     San Francisco 



pgsql-sql by date:

Previous
From: David Stanaway
Date:
Subject: Re: Math Huh?
Next
From: Larry Rosenman
Date:
Subject: Re: Math Huh?