summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlvaro Herrera <alvherre@alvh.no-ip.org>2013-07-02 12:21:16 -0400
committerAlvaro Herrera <alvherre@alvh.no-ip.org>2013-07-02 13:13:56 -0400
commit061c7a3c7adbf366707dd4c7fdfdb606d00b0dd7 (patch)
treef110c2a086de249ad0b63bbfaf9b53216f8c9ae1
parentae8fc624066398b8a14a97c5f950ddc844657d24 (diff)
Mention extra_float_digits in floating point docs
Make it easier for readers of the FP docs to find out about possibly truncated values. Per complaint from Tom Duffey in message F0E0F874-C86F-48D1-AA2A-0C5365BF5118@trillitech.com Author: Albe Laurenz Reviewed by: Abhijit Menon-Sen
-rw-r--r--doc/src/sgml/config.sgml1
-rw-r--r--doc/src/sgml/datatype.sgml11
2 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index c7d84b59ce2..efac9ebf642 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -5366,6 +5366,7 @@ SET XML OPTION { DOCUMENT | CONTENT };
partially-significant digits; this is especially useful for dumping
float data that needs to be restored exactly. Or it can be set
negative to suppress unwanted digits.
+ See also <xref linkend="datatype-float">.
</para>
</listitem>
</varlistentry>
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index f73e6b2e3a5..87668ea0c1c 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -681,6 +681,17 @@ NUMERIC
from zero will cause an underflow error.
</para>
+ <note>
+ <para>
+ The <xref linkend="guc-extra-float-digits"> setting controls the
+ number of extra significant digits included when a floating point
+ value is converted to text for output. With the default value of
+ <literal>0</literal>, the output is the same on every platform
+ supported by PostgreSQL. Increasing it will produce output that
+ more accurately represents the stored value, but may be unportable.
+ </para>
+ </note>
+
<indexterm>
<primary>not a number</primary>
<secondary>double precision</secondary>