Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under
Fedora Core and I'm writing queries through pgAdminIII. This is the query
that produces it:
select
billingplans_freetalktime.id, billingplans_freetalktime.seconds,
billingplans_freetalktime.accumulate, billingplans_freetalktime.period
from (billingplans_freetalktime inner join tariffs
on billingplans_freetalktime.tariff_id = tariffs.id_tariff)
where billingplans_freetalktime.plan_id = 5
and '3597' like tariffs.prefix||'%'
order by length(tariffs.prefix) desc;
and I get this:
row number -1 is out of range 0..-1
Total query runtime: 40 ms.
Data retrieval runtime: 60 ms.
0 rows retrieved.
I'll be glad if you can tell me how can I fix it. Do you know patch or
something?
-Bobi Ivanov
----- Original Message -----
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bobi Ivanov" <[EMAIL PROTECTED]>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, June 28, 2005 3:58 PM
Subject: Re: [BUGS] 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/
__________ NOD32 1.1155 (20050626) Information __________
This message was checked by NOD32 antivirus system.
http://www.nod32.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
