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 QAA95223 for ; Fri, 14 Jan 2000 16:27:25 -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 QAA01142; Fri, 14 Jan 2000 16:27:05 -0500 (EST) To: "Mitch Vincent" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] numeric question.. In-reply-to: <009b01bf5eb0$51d609e0$40ee2fd8@venux.net> References: <29298.947862153@sss.pgh.pa.us> <009b01bf5eb0$51d609e0$40ee2fd8@venux.net> Comments: In-reply-to "Mitch Vincent" message dated "Fri, 14 Jan 2000 11:56:36 -0500" Date: Fri, 14 Jan 2000 16:27:05 -0500 Message-ID: <1139.947885225@sss.pgh.pa.us> From: Tom Lane "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