Re: [SQL] avg() on numeric ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kaiq(at)realtyideas(dot)com
Cc: pgsql-sql(at)postgreSQL(dot)org, wieck(at)debis(dot)com (Jan Wieck)
Subject: Re: [SQL] avg() on numeric ?
Date: 1999-12-17 23:14:18
Message-ID: 11718.945472458@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<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.

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-12-17 23:25:01 Re: [SQL] Sub-select speed.
Previous Message kaiq 1999-12-17 22:44:34 avg() on numeric ?