patch-numeric-doc-v2.diff
text/x-diff
Filename: patch-numeric-doc-v2.diff
Type: text/x-diff
Part: 0
Message:
Re: maximum digits for NUMERIC
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: unified
Series: patch v2
| File | + | − |
|---|---|---|
| doc/src/sgml/datatype.sgml | 13 | 4 |
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 0bb6594..c426020 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -346,13 +346,13 @@
<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>
@@ -476,8 +476,8 @@
</indexterm>
<para>
- The type <type>numeric</type> can store numbers with up to 1000
- digits of precision and perform calculations exactly. It is
+ The type <type>numeric</type> can store numbers with a
+ large number of digits 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
@@ -525,6 +525,15 @@ NUMERIC
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