Question to datatype.sgml

Started by Tatsuo Ishiiover 6 years ago6 messagesdocs
Jump to latest
#1Tatsuo Ishii
t-ishii@sra.co.jp

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".

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

#2Vik Fearing
vik@postgresfriends.org
In reply to: Tatsuo Ishii (#1)
Re: Question to datatype.sgml

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

--

Vik Fearing

#3Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Vik Fearing (#2)
Re: Question to datatype.sgml

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

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tatsuo Ishii (#3)
Re: Question to datatype.sgml

Tatsuo Ishii <ishii@sraoss.co.jp> writes:

Can you please someone elaborate what's the meaning of "even" in
datatype.sgml?

representable values, in order to avoid a widespread bug where input
routines do not properly respect the round-to-even rule.) This value will

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.

I think actually the standard terminology is "round-to-nearest-even".

regards, tom lane

#5Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tom Lane (#4)
Re: Question to datatype.sgml

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.

I think actually the standard terminology is "round-to-nearest-even".

Ok, I will change it to "round-to-nearest-even" if there's no objection.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

#6Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tatsuo Ishii (#5)
Re: Question to datatype.sgml

I think actually the standard terminology is "round-to-nearest-even".

Ok, I will change it to "round-to-nearest-even" if there's no objection.

Done.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp