| Subject | Re: [firebird-support] Re: NUMERIC and DECIMAL |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-10-04T16:14:40Z |
Ann W. Harrison wrote:
and DECIMAL is integer. Precisions between 5 and 9 both use integer,
and precisions 10 and above both use int64.
Beats me why. Each of them will happily exceed the precision specified.
Regards,
Ann
>I was wrong, Rick is right. For precision < 5 NUMERIC is a small int
>
>>Actually, NUMERIC is stored as smallint and DECIMAL as integer.
and DECIMAL is integer. Precisions between 5 and 9 both use integer,
and precisions 10 and above both use int64.
Beats me why. Each of them will happily exceed the precision specified.
Regards,
Ann