"Peter Faulks" <pfaulks@...> wrote in message
news:20020411154947.10d0c28f.peter@......

> 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)
included.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing