postgres.git / summary / log / commit / refs

commit    b640d231230c486ed1b2b94167478fc8ced5dcff
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Mon Sep 08 02:40:41 2014 +0000

    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 56c47d1b5fd..cdb13a98d6e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -11642,14 +11642,13 @@ SELECT NULLIF(value, '(none)') ... <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> [parent: 52eed3d4267f]