<entry><type>decimal</></entry>

<entry>variable</entry>

<entry>user-specified precision, exact</entry>

<entry>no limit</entry>

<entry>up to 131072 digits before the decimal point; up to 16383 digits after the decimal point</entry>

</row>

<row>

<entry><type>numeric</></entry>

<entry>variable</entry>

<entry>user-specified precision, exact</entry>

<entry>no limit</entry>

<entry>up to 131072 digits before the decimal point; up to 16383 digits after the decimal point</entry>

</row>

<row>

</indexterm>

<para>

The type <type>numeric</type> can store numbers withup to 1000

digitsofprecision and perform calculations exactly. It is

The type <type>numeric</type> can store numbers witha

very large numberofdigits and perform calculations exactly. It is

especially recommended for storing monetary amounts and other

quantities where exactness is required. However, arithmetic on

<type>numeric</type> values is very slow compared to the integer

explicitly.)

</para>

<note>

<para>

The maximum allowed precision when explicitely specified in the

type declaration is 1000; otherwise the current implementation

of the <type>NUMERIC</type> is subject to the limits described

in <xref linkend="datatype-numeric-table">.

</para>

</note>

<para>

If the scale of a value to be stored is greater than the declared

scale of the column, the system will round the value to the specified