Subject Re: [ib-support] Re: decimal / numeric
Author Peter Faulks
On Tue, 9 Apr 2002 03:59:46 -0400 "Claudio Valderrama C." <cvalde@...>
wrote:

> 17) NUMERIC specifies the data type exact numeric, with the decimal
> precision and scale specified by the <precision> and <scale>.
>
> 18) DECIMAL, specifies the data type exact numeric, with the decimal
scale
> specified by the <scale> and the implementation-defined decimal
precision
> equal to or greater than the value of the specified <precision>.
>
> MsSql has true numeric. We only have true decimal.

And therefore rounding errors?

eg: SELECT SUM(<a_numeric_column) WHERE .....

Regards