From 4cadb8a560f589ae8840f25a80b1ba47a6957705 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 7 Sep 2014 22:40:41 -0400 Subject: [PATCH] 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. --- doc/src/sgml/func.sgml | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 2a39c244ee..f44c9cc876 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -11090,14 +11090,13 @@ SELECT NULLIF(value, '(none)') ... smallint, int, bigint, real, double - precision, numeric, or - interval + precision, numeric, + interval, or money bigint for smallint or int arguments, numeric for - bigint arguments, double precision - for floating-point arguments, otherwise the same as the + bigint arguments, otherwise the same as the argument data type sum of expression across all input values -- 2.40.0