Re: libpq ERROR: overflow on numeric ABS(value) ... - Mailing list pgsql-interfaces

From markw@osdl.org
Subject Re: libpq ERROR: overflow on numeric ABS(value) ...
Date
Msg-id 200308072223.h77MNQo24759@mail.osdl.org
Whole thread Raw
In response to Re: libpq ERROR: overflow on numeric ABS(value) ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
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
> 
>> 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


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
Next
From: markw@osdl.org
Date:
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...