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.