From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | vik(dot)fearing(at)2ndquadrant(dot)com |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Question to datatype.sgml |
Date: | 2019-12-30 02:07:36 |
Message-ID: | 20191230.110736.1393438990550013054.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
> On 30/12/2019 01:34, Tatsuo Ishii wrote:
>> Hi,
>>
>> Can you please someone elaborate what's the meaning of "even" in
>> datatype.sgml?
>>
>> <para>
>> By default, floating point values are output in text form in their
>> shortest precise decimal representation; the decimal value produced is
>> closer to the true stored binary value than to any other value
>> representable in the same binary precision. (However, the output value is
>> currently never <emphasis>exactly</emphasis> midway between two
>> representable values, in order to avoid a widespread bug where input
>> routines do not properly respect the round-to-even rule.) This value will
>> ~~~~~~~~~~~~~~~~~~~
>> use at most 17 significant decimal digits for <type>float8</type>
>> values, and at most 9 digits for <type>float4</type> values.
>> </para>
>>
>> I think "even" means "equality" here, not "even" of "even and odd".
>
>
> It does actually mean "even and odd". This kind of rounding is also
> called "Banker's Rounding".
>
> https://en.wikipedia.org/wiki/Rounding#Round_half_to_even
Oh, Thanks! The link is very helpful.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-12-30 04:51:59 | Re: Question to datatype.sgml |
Previous Message | Vik Fearing | 2019-12-30 00:52:48 | Re: Question to datatype.sgml |