> > Of course. These are integer fields? I've been considering changing
> > all accumulators (and results) for integer aggregate functions to
> > float8, but have not done so yet. I was sort of waiting for a v7.0
> > release, but am not sure why...
>
> Wouldn't it be better to use NUMERIC for the avg(int) state
> values? It will never loose any significant digit.
Sure. It would be fast, right? avg(int) is likely to be used a lot,
and should be as fast as possible.
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California