Kouhei Kaigai <kai...@ak.jp.nec.com> writes: > The documentation says that return type of sum(expression) is... > bigint for smallint or int arguments, numeric for bigint arguments, > double precision for floating-point arguments, otherwise the same > as the argument data type
> Does it expect sum(float4) returns float8, doesn't it? Good catch! [ digs in commit history... ] It looks like the claim that sum(float4) produces float8 was introduced in my commit d06ebdb8d3425185d7e641d15e45908658a0177d of 2000-07-17; but it seems to have been an outright error, because sum(float4) was a separate aggregate long before that. Possibly a copy-and-paste mistake from some other aggregate? I sure don't remember. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers