sum() function return type depends on input type

[phiresky]

int -> bigint bigint -> numeric float -> double precision other -> other

(see here)