postgres.git / summary / log / commit / refs

commit    e9ac1b8775c49a41374d85463f56aed73d512f25
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Tue Jul 02 16:21:16 2013 +0000
First released in: 9.4.0, 8.4.18, 9.0.14, 9.1.10, 9.2.5, 9.3.0

    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


doc/src/sgml/config.sgml | 1 + doc/src/sgml/datatype.sgml | 11 +++++++++++ 2 files changed, 12 insertions(+) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 1e575b26605..4791eb12400 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4285,6 +4285,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 b8dd8a5edce..4ea2b8a3662 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -663,6 +663,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> [parent: 17abf275f070]