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

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

From: markw(at)osdl(dot)org
To: pgsql-interfaces(at)postgresql(dot)org
Cc: osdldbt-general(at)lists(dot)sourceforge(dot)net
Subject: libpq ERROR: overflow on numeric ABS(value) ...
Date: 2003-08-07 21:25:03
Message-ID: 200308072125.h77LP7o07576@mail.osdl.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello, I need some help understanding an error message.  I've got a
program using libpq where I do a:
	DECLARE mycursor CURSOR FOR SELECT new_order(...)
	FETCH ALL IN mycursor

and I get the resulting error from the FETCH more than half the time:
	ERROR:  overflow on numeric ABS(value) >= 10^4 for field with precision 4 scale 0

My new_order function is a C library that returns an integer that
returns a number from 0 to 30.

Any ideas or suggestions?

Thanks!
-- 
Mark Wong - - markw(at)osdl(dot)org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503)-626-2455 x 32 (office)
(503)-626-2436      (fax)
http://www.osdl.org/archive/markw/

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2003-08-07 21:49:47
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
Previous:From: Bruce MomjianDate: 2003-08-07 14:15:22
Subject: Re: ecpg problem in 7.4 beta

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