Re: [SQL] avg() on numeric ?

<kaiq@realtyideas.com> writes:
> test=> select avg(quota) from salesreps;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0 scale 1723

> test=> select avg(sales) from salesreps;
> ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 0
> scale 1723

Hmm ... there were some similar bugs reported a couple of months ago,
and I thought Jan would've fixed them by now.  Jan, if you don't have
time to look at this, let me know and I'll see if I can do anything
with it.
        regards, tom lane