Thank you!
On Sun, Jun 24, 2018 at 6:08 PM Bruce Momjian <br...@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 <br...@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 ═════════
