Subject Re: [ib-support] Re: decimal / numeric
Author Claudio Valderrama C.
"Peter Faulks" <pfaulks@...> wrote in message
> On Wed, 10 Apr 2002 19:19:58 -0400 "Claudio Valderrama C."
> <cvalde@...> wrote:
> > 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.
> Thanks Claudio, I got my terms mixed up.

No surprise. From a programming language POV, when someone tells me about
the precision, I tend to think about decimal precision, IE the number of
decimal places that I want to get accurately from the result. However, SQL
has another concept: precision is the whole range, scale (decimal places)

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing