Subject | Re: NUMERIC or DECIMAL? |
---|---|
Author | sdbeames |
Post date | 2004-10-22T20:34:54Z |
> When I saw that Firebird/Interbase had a specific DECIMAL typethat allowed
> you to precisely identify the number of decimal points ofprecision to work
> with, I was overjoyed. No more rounding issues, truncationissues, etc. to
> deal with.have
>
> So I think that if you are dealing with data and applications that
> currency involved, limiting the amount of decimal precision is agood thing
> to have up your sleeve.But you're talking about the scale, rather than precision, aren't
you?
From DataDef.pdf....
The syntax for NUMERIC and DECIMAL is as follows:
NUMERIC[( precision [, scale])]
DECIMAL[( precision [, scale])]
(Are these terms the wrong way around? I'd have called the number of
decimal places the precision and the number of digits the scale
myself ;-) )
Both types allow fixed post-decimal point precision.
I'm more confused about the precision part...?
Cheers,
Steve