diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-09-07 22:40:41 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-09-07 22:40:56 -0400 |
| commit | b640d231230c486ed1b2b94167478fc8ced5dcff (patch) | |
| tree | f7a88dc13098a9a30ad0444a3b9c40ab2a3122aa /doc/src | |
| parent | 52eed3d4267faf671dae0450d99982cb9ba1ac52 (diff) | |
| download | postgresql-b640d231230c486ed1b2b94167478fc8ced5dcff.tar.gz postgresql-b640d231230c486ed1b2b94167478fc8ced5dcff.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files 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> |