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