Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA00511 for ; Fri, 14 Jan 2000 16:35:53 -0500 (EST) (envelope-from mitch@venux.net) Received: from inky (inky.venux.net [216.47.238.64]) by redbox.venux.net (Postfix) with SMTP id 7F6232E20B; Fri, 14 Jan 2000 16:28:20 -0500 (EST) Message-ID: <01ba01bf5ed7$c7e95340$40ee2fd8@venux.net> From: "Mitch Vincent" To: "Tom Lane" Cc: References: <29298.947862153@sss.pgh.pa.us> <009b01bf5eb0$51d609e0$40ee2fd8@venux.net> <1139.947885225@sss.pgh.pa.us> Subject: Re: [SQL] numeric question.. Date: Fri, 14 Jan 2000 16:39:05 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Hmm, ok Tom, thanks a lot for the information.. I tried doing them in decimal(9,2) too and well, it added them as numeric anyway -- I guess that's a dead end for a while? Thanks again.. -Mitch ----- Original Message ----- From: Tom Lane To: Mitch Vincent Cc: Sent: Friday, January 14, 2000 4:27 PM Subject: Re: [SQL] numeric question.. > "Mitch Vincent" writes: > > Query Failed > > ERROR: overflow on numeric ABS(value) >= 10^2 for field with precision 0 > > scale 2 > > That's a known bug in the NUMERIC code --- cause not known yet, but > apparently it's somewhat platform-dependent (or maybe there's more > than one bug?). I've been expecting Jan Wieck to produce a fix, since > NUMERIC is his turf, but he may be too busy with long-tuple support to > want to look at it. > > One way or another it will get seen to before 7.0 beta, and hopefully > we can produce a back-patch for 6.5.* as well. > > regards, tom lane >