From: markw@osdl.org
To: pgsql-interfaces@postgresql.org
Cc: osdldbt-general@lists.sourceforge.net
Subject: libpq ERROR: overflow on numeric ABS(value) ...
Date: Thu, 7 Aug 2003 14:25:03 -0700 (PDT)
Message-ID: <200308072125.h77LP7o07576@mail.osdl.org> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: markw@osdl.org, osdldbt-general@lists.sourceforge.net
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
In-Reply-To: <200308072125.h77LP7o07576@mail.osdl.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox