Subject Re: [firebird-support] Changing numeric domain to higher precsion
Author Ann W. Harrison
Bob Murdoch wrote:
> I have the following domain defined and in use by every column used to
> store information on US dollars:
>
> 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)?

No.

Regards,


Ann