summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2014-09-07 22:40:41 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2014-09-07 22:40:51 -0400
commitb1a7c9e387f77b85aa14eb342f0432fcdb6ddc35 (patch)
treef2f83d9998ddbcc88b3416fd24d62536196fc592
parent4231599328f75d6549831f65223a22236a43a5c9 (diff)
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.sgml7
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 77920f4706f..8fa8d8f435d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -12246,14 +12246,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>