Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA67555 for ; Fri, 17 Dec 1999 18:15:33 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id SAA11721; Fri, 17 Dec 1999 18:14:18 -0500 (EST) To: kaiq@realtyideas.com cc: pgsql-sql@postgreSQL.org, wieck@debis.com (Jan Wieck) Subject: Re: [SQL] avg() on numeric ? In-reply-to: Your message of Fri, 17 Dec 1999 16:44:34 -0600 (CST) Date: Fri, 17 Dec 1999 18:14:18 -0500 Message-ID: <11718.945472458@sss.pgh.pa.us> From: Tom Lane 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