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.