Subject | Re: [ib-support] Re: decimal / numeric |
---|---|

Author | Claudio Valderrama C. |

Post date | 2002-04-11T07:16:32Z |

"Peter Faulks" <pfaulks@...> wrote in message

news:20020411154947.10d0c28f.peter@......

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

news:20020411154947.10d0c28f.peter@......

> On Wed, 10 Apr 2002 19:19:58 -0400 "Claudio Valderrama C."No surprise. From a programming language POV, when someone tells me about

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

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