On Sun, Apr 3, 2011 at 11:23 PM, Robert Haas <robertmh...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
