Skip to content

Commit 4cadb8a

Browse files
committed
Documentation fix: sum(float4) returns float4, not float8.
The old claim is from my commit d06ebdb 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.
1 parent 78b1228 commit 4cadb8a

File tree

1 file changed

+3
-4
lines changed

1 file changed

+3
-4
lines changed

doc/src/sgml/func.sgml

Lines changed: 3 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -11090,14 +11090,13 @@ SELECT NULLIF(value, '(none)') ...
1109011090
<entry>
1109111091
<type>smallint</type>, <type>int</type>,
1109211092
<type>bigint</type>, <type>real</type>, <type>double
11093-
precision</type>, <type>numeric</type>, or
11094-
<type>interval</type>
11093+
precision</type>, <type>numeric</type>,
11094+
<type>interval</type>, or <type>money</>
1109511095
</entry>
1109611096
<entry>
1109711097
<type>bigint</type> for <type>smallint</type> or
1109811098
<type>int</type> arguments, <type>numeric</type> for
11099-
<type>bigint</type> arguments, <type>double precision</type>
11100-
for floating-point arguments, otherwise the same as the
11099+
<type>bigint</type> arguments, otherwise the same as the
1110111100
argument data type
1110211101
</entry>
1110311102
<entry>sum of <replaceable class="parameter">expression</replaceable> across all input values</entry>

0 commit comments

Comments
 (0)