Link to "Upgrading a PostgreSQL Cluster" in Release Notes
Following a complaint on IRC about the dearth of information on how to migrate to a new major version in the release notes, the attached trivial patch was determined to be sufficient for the OP. This patch applies to REL_12_STABLE. I don't know how far it should be backpatched (the OP was trying to upgrade to v10), and I didn't see any place to put it for 13 and future versions. -- Vik Fearing diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml index dfa3851913..62cdbba2d5 100644 --- a/doc/src/sgml/release-12.sgml +++ b/doc/src/sgml/release-12.sgml @@ -1216,6 +1216,8 @@ Branch: REL9_4_STABLE [8f8809091] 2019-10-04 15:38:36 -0400 A dump/restore using , or use of , is required for those wishing to migrate data from any previous release. +See for general information on migrating to +new major releases.
Question to datatype.sgml
Hi, Can you please someone elaborate what's the meaning of "even" in datatype.sgml? 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 exactly 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 float8 values, and at most 9 digits for float4 values. 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
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? > > > 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 exactly 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 float8 > values, and at most 9 digits for float4 values. > > > 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
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? >> >> >> 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 exactly 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 float8 >> values, and at most 9 digits for float4 values. >> >> >> 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
Re: Question to datatype.sgml
Tatsuo Ishii 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
