Subject Re: [firebird-support] Re: Is this a bug in ROUND function?
Author Mark Rotteveel
On 2019-08-30 04:33, Richard Damon richard@...
[firebird-support] wrote:
> On 8/29/19 3:14 PM, 'Alan McDonald' alan@... [firebird-support]
> wrote:
> numeric(18, 3) will use a double for its internal representation, but I
> would think it should still work. It might make more sense to use a
> width of 9 or less, unless elsewhere you are actually using bigger
> numbers.

NUMERIC(18,3) uses BIGINT for its internal representation in dialect 3.
Only in dialect 1 does it use DOUBLE PRECISION, and dialect 1 was
deprecated 20 years ago.