Re: libpq ERROR: overflow on numeric ABS(value) ...

On 7 Aug, Tom Lane wrote:
> markw(at)osdl(dot)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