X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 6583FD1D2C4
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 21:25:21 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 36154-03
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 18:23:58 -0300 (ADT)
Received: from mail.osdl.org (fw.osdl.org [65.172.181.6])
	by svr1.postgresql.org (Postfix) with ESMTP id ACA91D1CFFC
	for <pgsql-interfaces@postgresql.org>;
	Thu,  7 Aug 2003 18:25:09 -0300 (ADT)
Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51])
	by mail.osdl.org (8.11.6/8.11.6) with ESMTP id h77LP7o07576;
	Thu, 7 Aug 2003 14:25:08 -0700
Message-Id: <200308072125.h77LP7o07576@mail.osdl.org>
Date: Thu, 7 Aug 2003 14:25:03 -0700 (PDT)
From: markw@osdl.org
Subject: libpq ERROR:  overflow on numeric ABS(value) ...
To: pgsql-interfaces@postgresql.org
Cc: osdldbt-general@lists.sourceforge.net
MIME-Version: 1.0
Content-Type: TEXT/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/31
X-Sequence-Number: 4385

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@osdl.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/