Skip site navigation (1) Skip section navigation (2)

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

From: markw(at)osdl(dot)org
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-interfaces(at)postgresql(dot)org,osdldbt-general(at)lists(dot)sourceforge(dot)net
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
Date: 2003-08-08 00:02:12
Message-ID: 200308080002.h7802Fo15143@mail.osdl.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
On  7 Aug, To: tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
> 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?

Oh wait, I got it figured out.  I'm getting smaller than -9999...  :(

In response to

pgsql-interfaces by date

Next:From: Frank van VugtDate: 2003-08-08 08:46:10
Subject: SOLVED: Multi-threaded Qt app segfaults when using libpq with separate connections
Previous:From: markwDate: 2003-08-07 23:53:03
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group