On 7 Aug, Tom Lane wrote:
> markw@osdl.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
Ok, found the offending statement:UPDATE stockSET s_quantity = s_quantity - 4WHERE s_i_id = 28472 AND s_w_id =
2
s_quantity is defined as NUMERIC(4). So does this means s_quantity must
be a positive number? Should I use a different data type?
Thanks,
Mark