bug in 6.5.3...

I looked in the "TODO" list and didn't find any mention of
avg() or relevant items regarding aggregates so here's my
bug du jour:

acs=> create table foo(p numeric(9,2));
CREATE
acs=> select avg(p) from foo;
ERROR: overflow on numeric ABS(value) >= 10^-1 for field with precision 0
scale 1723
acs=>
acs=> insert into foo values(3);
INSERT 1014409 1
acs=> select avg(p) from foo;
ERROR: overflow on numeric ABS(value) >= 10^-1 for field with precision 0
scale 1723
acs=> select p from foo;
p
----
3.00
(1 row)

acs=> select max(p) from foo;
max
----
3.00
(1 row)

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.