Casting issue with aggregated function - Mailing list pgsql-general

Hi,

I'm facing a cast issue when using sub queries and I 'd like your opinion if this should be submittede as a Bug.

(Postgres version 8.1.0)

Compare:

A)

select sum(25665800) as c

        => 25665800 (int8)

B)

select sum(c) from
(
select sum(25665800) as c
)foo

        => 25665800 (numeric)

I find the cast form int8 to numeric being strange.

Cheers,

Marc