postgres.git / summary / log / commit / refs

commit    278edd9ed36c7722cbae27e0e96a08964da69eb5
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Mar 24 23:57:52 2015 +0000
First released in: 9.5.0

    doc:  update NUMERIC to state that only some ops are exact
    
    Report by Tom Lane


doc/src/sgml/datatype.sgml | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index edf636b4417..da1f25fe285 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -498,11 +498,13 @@ <para> The type <type>numeric</type> can store numbers with a - very large number of digits and perform calculations exactly. It is - especially recommended for storing monetary amounts and other - quantities where exactness is required. However, arithmetic on - <type>numeric</type> values is very slow compared to the integer - types, or to the floating-point types described in the next section. + very large number of digits. It is especially recommended for + storing monetary amounts and other quantities where exactness is + required. Calculations with <type>numeric</type> values yield exact + results where possible, e.g. addition, subtraction, multiplication. + However, calculations on <type>numeric</type> values are very slow + compared to the integer types, or to the floating-point types + described in the next section. </para> <para> [parent: 1d8198bb44e7]