Re: [SQL] avg() on numeric ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] avg() on numeric ?
Date
Msg-id 11718.945472458@sss.pgh.pa.us
Whole thread Raw
In response to avg() on numeric ?  (<kaiq@realtyideas.com>)
Responses Re: [SQL] avg() on numeric ?  (wieck@debis.com (Jan Wieck))
List pgsql-sql
<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.
        regards, tom lane


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] Sub-select speed.
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Sub-select speed.