>
> <kaiq@realtyideas.com> writes:
> > test=> select avg(quota) from salesreps;
> > ERROR: overflow on numeric ABS(value) >= 10^-1 for field with precision 0 scale 1723
>
> > test=> select avg(sales) from salesreps;
> > ERROR: overflow on numeric ABS(value) >= 10^-1 for field with precision 0
> > scale 1723
>
> Hmm ... there were some similar bugs reported a couple of months ago,
> and I thought Jan would've fixed them by now. Jan, if you don't have
> time to look at this, let me know and I'll see if I can do anything
> with it.
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.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck@debis.com (Jan Wieck) #