Re: [SQL] avg() on numeric ?

>
> <kaiq(at)realtyideas(dot)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(at)debis(dot)com (Jan Wieck) #