> Bob Murdoch wrote:
>
>>
>>create domain MONEY_D as numeric(9,2);
>>
>>I have found that some queries are now returning values in excess of
>>10M, which causes an 'arithmetic exception, numeric overflow, or
>>string truncation' error.
>>
>>Is there any problem with modifying this domain to something like,
>>say, numeric(15,2)?
>

Ann W. Harrison wrote:

> No.
>

And of course, Martijn is right, anything with a precision over 9 does
become double precision in dialect 1. However, the alternative of not
accepting large orders is not attractive. Unless you're doing
multiplication or division, and until you approach a precision of 15,
double should be stable enough.

Regards,


Ann