Skip to content

Commit ca871e7

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 c4f386f commit ca871e7

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
@@ -5244,6 +5244,7 @@ SET XML OPTION { DOCUMENT | CONTENT };
52445244
partially-significant digits; this is especially useful for dumping
52455245
float data that needs to be restored exactly. Or it can be set
52465246
negative to suppress unwanted digits.
5247+
See also <xref linkend="datatype-float">.
52475248
</para>
52485249
</listitem>
52495250
</varlistentry>

doc/src/sgml/datatype.sgml

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

694+
<note>
695+
<para>
696+
The <xref linkend="guc-extra-float-digits"> setting controls the
697+
number of extra significant digits included when a floating point
698+
value is converted to text for output. With the default value of
699+
<literal>0</literal>, the output is the same on every platform
700+
supported by PostgreSQL. Increasing it will produce output that
701+
more accurately represents the stored value, but may be unportable.
702+
</para>
703+
</note>
704+
694705
<indexterm>
695706
<primary>not a number</primary>
696707
<secondary>double precision</secondary>

0 commit comments

Comments
 (0)