diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-09-07 22:40:41 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-09-07 22:40:41 -0400 |
| commit | 0640c1bfc09138f136fc1239d2c27b6d37f7d1af (patch) | |
| tree | de3fa2ec790530e580a20e0178f4798639ca673b | |
| parent | b2de2a1172d52b9a9596d4366e758749cc586f2b (diff) | |
| download | postgresql-0640c1bfc09138f136fc1239d2c27b6d37f7d1af.tar.gz postgresql-0640c1bfc09138f136fc1239d2c27b6d37f7d1af.zip | |
Documentation fix: sum(float4) returns float4, not float8.
The old claim is from my commit d06ebdb8d3425185d7e641d15e45908658a0177d of
2000-07-17, but it seems to have been a plain old thinko; sum(float4) has
been distinct from sum(float8) since Berkeley days. Noted by KaiGai Kohei.
While at it, mention the existence of sum(money), which is also of
embarrassingly ancient vintage.
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e50408cb977..84e58944ce2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -12248,14 +12248,13 @@ NULL baz</literallayout>(3 rows)</entry> <entry> <type>smallint</type>, <type>int</type>, <type>bigint</type>, <type>real</type>, <type>double - precision</type>, <type>numeric</type>, or - <type>interval</type> + precision</type>, <type>numeric</type>, + <type>interval</type>, or <type>money</> </entry> <entry> <type>bigint</type> for <type>smallint</type> or <type>int</type> arguments, <type>numeric</type> for - <type>bigint</type> arguments, <type>double precision</type> - for floating-point arguments, otherwise the same as the + <type>bigint</type> arguments, otherwise the same as the argument data type </entry> <entry>sum of <replaceable class="parameter">expression</replaceable> across all input values</entry> |