From: Mitch Vincent <mitch@venux.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] numeric question..
Date: Fri, 14 Jan 2000 16:39:05 -0500
Message-ID: <01ba01bf5ed7$c7e95340$40ee2fd8@venux.net> (raw)
References: <Pine.GSO.3.96.1000113235142.2456A-100000@sanmarino.tcsi.com>
<29298.947862153@sss.pgh.pa.us>
<009b01bf5eb0$51d609e0$40ee2fd8@venux.net>
<1139.947885225@sss.pgh.pa.us>
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 <tgl@sss.pgh.pa.us>
To: Mitch Vincent <mitch@venux.net>
Cc: <pgsql-sql@postgreSQL.org>
Sent: Friday, January 14, 2000 4:27 PM
Subject: Re: [SQL] numeric question..
> "Mitch Vincent" <mitch@venux.net> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mitch@venux.net, tgl@sss.pgh.pa.us
Subject: Re: [SQL] numeric question..
In-Reply-To: <01ba01bf5ed7$c7e95340$40ee2fd8@venux.net>
References: <Pine.GSO.3.96.1000113235142.2456A-100000@sanmarino.tcsi.com> <29298.947862153@sss.pgh.pa.us> <009b01bf5eb0$51d609e0$40ee2fd8@venux.net> <1139.947885225@sss.pgh.pa.us> <01ba01bf5ed7$c7e95340$40ee2fd8@venux.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox