Re: row number -1 is out of range 0..-1

On Tue, Jun 28, 2005 at 03:11:03PM +0300, Bobi Ivanov wrote:
>
>     I get this message 'row number -1 is out of range 0..-1' sometimes.
> I say sometimes, because this happens unexpected when I submit absolutely
> correct query. Query succeeds, but it returns no resul although there should be.

The above error happens if a program calls PQgetvalue(), PQgetlength(),
or PQgetisnull() with a row number of -1 and if there were no rows
in the result.  Are you calling those libpq functions directly, or
are you using an interface that sits on top of libpq?  If the latter,
what interface and version are you using?  What version of PostgreSQL?
What does your code look like?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/