Numeric documentation paragraph reverse argument order.

On Fri, Jun 22, 2018 at 01:54:26PM +0000, PG Doc comments form wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/datatype-numeric.html
Description:

This is not a correction, but a clarification. In the paragraph describing
the Numeric type,
https://www.postgresql.org/docs/10/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
the description of the arguments is reversed from the order of the
arguments, i.e. scale before numeric, while the argument is numeric before
scale. My suggestion is to change the following paragraph:

We use the following terms below: The scale of a numeric is the count of

decimal digits in the fractional part, to the right of the decimal point.
The precision of a numeric is the total count of significant digits in the
whole number, that is, the number of digits to both sides of the decimal
point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers
can be considered to have a scale of zero.

to:

We use the following terms below: The precision of a numeric is the total

count of significant digits in the whole number, that is, the number of
digits to both sides of the decimal point. The scale of a numeric is the
count of decimal digits in the fractional part, to the right of the decimal
point. So the number 23.5141 has a precision of 6 and a scale of 4. Integers
can be considered to have a scale of zero.

That way the order in the paragraph (precision, scale), matches the argument
order `NUMERIC(precision, scale)`

Now that is an excellent suggestion. Change applied back through 9.3.
Thanks.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

Thank you!

On Sun, Jun 24, 2018 at 6:08 PM Bruce Momjian <bruce@momjian.us> wrote:

On Fri, Jun 22, 2018 at 01:54:26PM +0000, PG Doc comments form wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/datatype-numeric.html
Description:

This is not a correction, but a clarification. In the paragraph

describing

the Numeric type,

https://www.postgresql.org/docs/10/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL

the description of the arguments is reversed from the order of the
arguments, i.e. scale before numeric, while the argument is numeric

before

scale. My suggestion is to change the following paragraph:

We use the following terms below: The scale of a numeric is the count

of

decimal digits in the fractional part, to the right of the decimal point.
The precision of a numeric is the total count of significant digits in

the

whole number, that is, the number of digits to both sides of the decimal
point. So the number 23.5141 has a precision of 6 and a scale of 4.

Integers

can be considered to have a scale of zero.

to:

We use the following terms below: The precision of a numeric is the

total

count of significant digits in the whole number, that is, the number of
digits to both sides of the decimal point. The scale of a numeric is the
count of decimal digits in the fractional part, to the right of the

decimal

point. So the number 23.5141 has a precision of 6 and a scale of 4.

Integers

can be considered to have a scale of zero.

That way the order in the paragraph (precision, scale), matches the

argument

order `NUMERIC(precision, scale)`

Now that is an excellent suggestion. Change applied back through 9.3.
Thanks.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

--
═════════
Clayton Salem
413-768-8522
═════════