Re: Numeric documentation paragraph reverse argument order.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: claytonjsalem(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Numeric documentation paragraph reverse argument order.
Date: 2018-06-24 22:08:00
Message-ID: 20180624220800.GE17816@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(at)momjian(dot)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 +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Clayton Salem 2018-06-24 22:08:25 Re: Numeric documentation paragraph reverse argument order.
Previous Message Bruce Momjian 2018-06-24 03:33:23 Re: DATE_PART('field', INTERVAL) not intuitive literal reading of interval