Subject Re: [Firebird-Architect] NUMERIC vs DECIMAL
Author Ann Harrison
In Firebird numeric and decimal map into exactly the same types. In the
SQL-92 standard:

16) For the <exact numeric type>s DECIMAL and NUMERIC:
a) The maximum value of <precision> is implementation-defined.
<precision> shall not be
greater than this value.
b) The maximum value of <scale> is implementation-defined. <scale>
shall not be greater than
this maximum value.
17) NUMERIC specifies the data type exact numeric, with the decimal
precision and scale specified
by the <precision> and <scale>.
18) DECIMAL, specifies the data type exact numeric, with the decimal
scale specified by the <scale>
and the implementation-defined decimal precision equal to or
greater than the value of the
specified <precision>.

Regards,


Ann