Skip to content

Commit b640d23

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 52eed3d commit b640d23

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
@@ -11642,14 +11642,13 @@ SELECT NULLIF(value, '(none)') ...
1164211642
<entry>
1164311643
<type>smallint</type>, <type>int</type>,
1164411644
<type>bigint</type>, <type>real</type>, <type>double
11645-
precision</type>, <type>numeric</type>, or
11646-
<type>interval</type>
11645+
precision</type>, <type>numeric</type>,
11646+
<type>interval</type>, or <type>money</>
1164711647
</entry>
1164811648
<entry>
1164911649
<type>bigint</type> for <type>smallint</type> or
1165011650
<type>int</type> arguments, <type>numeric</type> for
11651-
<type>bigint</type> arguments, <type>double precision</type>
11652-
for floating-point arguments, otherwise the same as the
11651+
<type>bigint</type> arguments, otherwise the same as the
1165311652
argument data type
1165411653
</entry>
1165511654
<entry>sum of <replaceable class="parameter">expression</replaceable> across all input values</entry>

0 commit comments

Comments
 (0)