On Sun, Apr 3, 2011 at 11:23 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> Thanks for the patch, but I think you forgot to worry about overflow:
>
> rhaas=# select 9223372036854775807::money;
> money
> --------
> -$1.00
> (1 row)
cash_in doesn't test for overflow, either (tested on 8.4.0, 9.0.3, and HEAD):
joey=# select '9223372036854775807'::money;
money
--------
-$1.00
(1 row)
Is this a bug?
Detail: unlike cash_in, numeric_cash does check for overflow
(implicitly, through its use of numeric_int8).
Joey Adams