Re: [SQL] numeric question..

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(at)sss(dot)pgh(dot)pa(dot)us>
To: Mitch Vincent <mitch(at)venux(dot)net>
Cc: <pgsql-sql(at)postgreSQL(dot)org>
Sent: Friday, January 14, 2000 4:27 PM
Subject: Re: [SQL] numeric question..

> "Mitch Vincent" <mitch(at)venux(dot)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
>