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
>