On 7 Aug, Tom Lane wrote:
> markw(at)osdl(dot)org writes:
>>>> DECLARE mycursor CURSOR FOR SELECT new_order(...)
>>>> FETCH ALL IN mycursor
>>>> ERROR: overflow on numeric ABS(value) >= 10^4 for field with precision 4 scale 0
>
>> Does it make sense that is throws the error on the FETCH instead of the
>> previous statement?
>
> Sure: the cursor won't actually be executed until you fetch from it.
Oh right, I should have remembered that...
Thanks,
Mark