8000 Mention extra_float_digits in floating point docs · sqlparser/postgres@1a1e797 · GitHub
[go: up one dir, main page]

Skip to content

Commit 1a1e797

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 76ce043 commit 1a1e797

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
@@ -4739,6 +4739,7 @@ SET XML OPTION { DOCUMENT | CONTENT };
47394739
partially-significant digits; this is especially useful for dumping
47404740
float data that needs to be restored exactly. Or it can be set
47414741
negative to suppress unwanted digits.
4742+
See also <xref linkend="datatype-float">.
47424743
</para>
47434744
</listitem>
47444745
</varlistentry>

doc/src/sgml/datatype.sgml

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

666+
<note>
667+
<para>
668+
The <xref linkend="guc-extra-float-digits"> setting controls the
669+
number of extra significant digits included when a floating point
670+
value is converted to text for output. With the default value of
671+
<literal>0</literal>, the output is the same on every platform
672+
supported by PostgreSQL. Increasing it will produce output that
673+
more accurately represents the stored value, but may be unportable.
674+
</para>
675+
</note>
676 47D4 +
666677
<indexterm>
667678
<primary>not a number</primary>
668679
<secondary>double precision</secondary>

0 commit comments

Comments
 (0)
0