Re: avg() bug?

Thanks Tom!

I'll use sum(a::int4) until 7.1 then.

Regards,
Patrik Kudo

ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!

On Mon, 5 Mar 2001, Tom Lane wrote:

> Patrik Kudo <kudo(at)partitur(dot)se> writes:
> > I suppose avg() does a sum()/count() where sum returns a int2,
> > which will be too small to contain the sum if the table contains
> > many values?
>
> Yes. This is changed in 7.1 --- sum() and avg() of int values now
> return type 'numeric'.
>
> regards, tom lane
>