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/