Re: [SQL] avg() on numeric ?

>
> <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) #