Subject | Re: [firebird-support] Changing numeric domain to higher precsion |
---|---|
Author | Ann W. Harrison |
Post date | 2005-02-21T19:42:20Z |
Bob Murdoch wrote:
Regards,
Ann
> I have the following domain defined and in use by every column used toNo.
> 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)?
Regards,
Ann