Subject Re: [ib-support] Re: decimal / numeric
Author Claudio Valderrama C.
"Peter Faulks" <pfaulks@...> wrote in message
> And therefore rounding errors?
> eg: SELECT SUM(<a_numeric_column) WHERE .....

Nothing to do.
Here, precision is the total number of digits in the number. It's not
related to arithmetic rounding at all. From that "precision", some places
are reserved for the scale, that's the decimal places.
Any documentation you may read (SQL standard, IB documentation) uses
numeric(precision, scale)
decimal(precision, scale)