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@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.