Re: libpq ERROR: overflow on numeric ABS(value) ... - Mailing list pgsql-interfaces

From markw@osdl.org
Subject Re: libpq ERROR: overflow on numeric ABS(value) ...
Date
Msg-id 200308072156.h77LuUo16238@mail.osdl.org
Whole thread Raw
In response to Re: libpq ERROR: overflow on numeric ABS(value) ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: libpq ERROR: overflow on numeric ABS(value) ...
List pgsql-interfaces
On  7 Aug, Tom Lane wrote:
> markw@osdl.org writes:
>> Hello, I need some help understanding an error message.  I've got a
>> program using libpq where I do a:
>>     DECLARE mycursor CURSOR FOR SELECT new_order(...)
>>     FETCH ALL IN mycursor
> 
>> and I get the resulting error from the FETCH more than half the time:
>>     ERROR:  overflow on numeric ABS(value) >= 10^4 for field with precision 4 scale 0
> 
>> My new_order function is a C library that returns an integer that
>> returns a number from 0 to 30.
> 
> I'm betting on a bug in your C code.  But we can't guess what without
> more details.
> 

Does it make sense that is throws the error on the FETCH instead of the
previous statement?  I've attached the table definitions, create
function statement, and the C stored function.  Does that help?

Thanks,
Mark

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
Next
From: Tom Lane
Date:
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...