Re: Numeric documentation paragraph reverse argument order.

Thank you!

On Sun, Jun 24, 2018 at 6:08 PM Bruce Momjian <bruce(at)momjian(dot)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(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 +
>
--
═════════
Clayton Salem
413-768-8522
═════════