Re: [SQL] numeric question.. - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] numeric question..
Date
Msg-id 1139.947885225@sss.pgh.pa.us
Whole thread Raw
In response to numeric question..  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: Mark Volpe
Date:
Subject: Re: Aggregates & Views
Next
From: "Mitch Vincent"
Date:
Subject: Re: [SQL] numeric question..