Re: [SQL] avg() on numeric ?

wieck(at)debis(dot)com (Jan Wieck) writes:
> Looks to me there's something wrong with the adjustment of
> actual computation and/or display precision during longer
> taking aggregates. I know where to look at - tnx anyway.

It doesn't necessarily take long; Zot O'Connor posted this example
in late October:

create table example(other decimal(4,4));
CREATE

insert into example (other) values(3.9);
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4
insert into example (other) values(0.0);
ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4

which still fails in current sources.

regards, tom lane