Skip to content

Commit 8455b70

Browse files
committed
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
1 parent 50e66d3 commit 8455b70

File tree

2 files changed

+12
-0
lines changed

2 files changed

+12
-0
lines changed

doc/src/sgml/config.sgml

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5024,6 +5024,7 @@ SET XML OPTION { DOCUMENT | CONTENT };
50245024
partially-significant digits; this is especially useful for dumping
50255025
float data that needs to be restored exactly. Or it can be set
50265026
negative to suppress unwanted digits.
5027+
See also <xref linkend="datatype-float">.
50275028
</para>
50285029
</listitem>
50295030
</varlistentry>

doc/src/sgml/datatype.sgml

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -672,6 +672,17 @@ NUMERIC
672672
from zero will cause an underflow error.
673673
</para>
674674

675+
<note>
676+
<para>
677+
The <xref linkend="guc-extra-float-digits"> setting controls the
678+
number of extra significant digits included when a floating point
679+
value is converted to text for output. With the default value of
680+
<literal>0</literal>, the output is the same on every platform
681+
supported by PostgreSQL. Increasing it will produce output that
682+
more accurately represents the stored value, but may be unportable.
683+
</para>
684+
</note>
685+
675686
<indexterm>
676687
<primary>not a number</primary>
677688
<secondary>double precision</secondary>

0 commit comments

Comments
 (0)