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
Ok, found the offending statement:
UPDATE stock
SET s_quantity = s_quantity - 4
WHERE 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