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 Service and other goodies at
  http://donb.photo.net.

Tue, 11 Jan 2000 18:15:39 -0800
Don Baccus <dhogaza@pacifier.com>
bug in 6.5.3...
Don Baccus <dhogaza@pacifier.com> writes:
> 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

That's a known bug I believe (Jan, are you paying attention?).  It seems
to be platform-dependent --- in current sources, I see no failure on an
HPUX box, but a Linux box fails with
ERROR:  overflow on numeric ABS(value) >= 10^-1 for field with precision 2077 scale 22808
Maybe a big-vs-little-endian kind of problem?

			regards, tom lane

Wed, 12 Jan 2000 01:33:01 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] bug in 6.5.3... 