Subject Re: NUMERIC or DECIMAL?
Author sdbeames
> When I saw that Firebird/Interbase had a specific DECIMAL type
that allowed
> you to precisely identify the number of decimal points of
precision to work
> with, I was overjoyed. No more rounding issues, truncation
issues, etc. to
> deal with.
>
> So I think that if you are dealing with data and applications that
have
> currency involved, limiting the amount of decimal precision is a
good 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