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