Re: [SQL] numeric question..

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
Subject: Re: [SQL] numeric question..
Date: 2000-01-14 21:27:05
Message-ID: 1139.947885225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mitch Vincent 2000-01-14 21:39:05 Re: [SQL] numeric question..
Previous Message Mark Volpe 2000-01-14 21:19:17 Re: Aggregates & Views