Re: libpq ERROR: overflow on numeric ABS(value) ... - Mailing 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