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 UAA95861 for ; Fri, 17 Dec 1999 20:11:52 -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 UAA29409; Fri, 17 Dec 1999 20:10:37 -0500 (EST) To: wieck@debis.com (Jan Wieck) cc: kaiq@realtyideas.com, pgsql-sql@postgreSQL.org Subject: Re: [SQL] avg() on numeric ? In-reply-to: Your message of Sat, 18 Dec 1999 00:43:51 +0100 (MET) Date: Fri, 17 Dec 1999 20:10:37 -0500 Message-ID: <29406.945479437@sss.pgh.pa.us> From: Tom Lane wieck@debis.com (Jan Wieck) writes: > 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. It doesn't necessarily take long; Zot O'Connor posted this example in late October: create table example(other decimal(4,4)); CREATE insert into example (other) values(3.9); ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4 insert into example (other) values(0.0); ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4 which still fails in current sources. regards, tom lane