postgres.git / summary / log / commit / refs

commit    6350dcc1f43154d404f52ab4e891ebecef0c2115
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sun Jun 24 22:07:00 2018 +0000

    doc:  adjust order of NUMERIC arguments to match syntax
    
    Specifically, mention precision before scale
    
    Reported-by: claytonjsalem@gmail.com
    
    Discussion: https://postgr.es/m/152967566691.1268.1062965601465200209@wrigleys.postgresql.org
    
    Backpatch-through: 9.3


doc/src/sgml/datatype.sgml | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 2cfba1d36d2..6b480f465b0 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -515,14 +515,13 @@ <para> We use the following terms below: The - <firstterm>scale</firstterm> of a <type>numeric</type> is the - count of decimal digits in the fractional part, to the right of - the decimal point. The <firstterm>precision</firstterm> of a - <type>numeric</type> 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. + <firstterm>precision</firstterm> of a <type>numeric</type> + 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 <firstterm>scale</firstterm> of a <type>numeric</type> 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. </para> <para> [parent: c1975c1af7c2]