Subject | Re: [ib-support] Re: decimal / numeric |
---|---|
Author | Peter Faulks |
Post date | 2002-04-09T08:55:52Z |
On Tue, 9 Apr 2002 03:59:46 -0400 "Claudio Valderrama C." <cvalde@...>
wrote:
eg: SELECT SUM(<a_numeric_column) WHERE .....
Regards
wrote:
> 17) NUMERIC specifies the data type exact numeric, with the decimalscale
> precision and scale specified by the <precision> and <scale>.
>
> 18) DECIMAL, specifies the data type exact numeric, with the decimal
> specified by the <scale> and the implementation-defined decimalprecision
> equal to or greater than the value of the specified <precision>.And therefore rounding errors?
>
> MsSql has true numeric. We only have true decimal.
eg: SELECT SUM(<a_numeric_column) WHERE .....
Regards