wieck@debis.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