diff options
| author | Bruce Momjian <bruce@momjian.us> | 2015-03-24 19:57:52 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2015-03-24 19:57:52 -0400 |
| commit | 278edd9ed36c7722cbae27e0e96a08964da69eb5 (patch) | |
| tree | aa27f50d0325833d0a05d942512c7d2e375dccc5 | |
| parent | 1d8198bb44e7e7e3e96d96942f642e9964111628 (diff) | |
| download | postgresql-278edd9ed36c7722cbae27e0e96a08964da69eb5.tar.gz postgresql-278edd9ed36c7722cbae27e0e96a08964da69eb5.zip | |
doc: update NUMERIC to state that only some ops are exact
Report by Tom Lane
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 12 |
1 files 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> |