Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id SAA76410 for ; Fri, 17 Dec 1999 18:53:43 -0500 (EST) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m11z72N-0003kKC; Sat, 18 Dec 99 00:43 MET Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] avg() on numeric ? To: tgl@sss.pgh.pa.us (Tom Lane) Date: Sat, 18 Dec 1999 00:43:51 +0100 (MET) Cc: kaiq@realtyideas.com, pgsql-sql@postgreSQL.org, wieck@debis.com Reply-To: wieck@debis.com (Jan Wieck) In-Reply-To: <11718.945472458@sss.pgh.pa.us> from "Tom Lane" at Dec 17, 99 06:14:18 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > 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) #