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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: markw(at)osdl(dot)org
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-07 21:49:47
Message-ID: 8867.1060292987@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
markw(at)osdl(dot)org writes:
> 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.

I'm betting on a bug in your C code.  But we can't guess what without
more details.

			regards, tom lane

In response to

Responses

pgsql-interfaces by date

Next:From: markwDate: 2003-08-07 21:56:27
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ...
Previous:From: markwDate: 2003-08-07 21:25:03
Subject: libpq ERROR: overflow on numeric ABS(value) ...

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