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

Re: BUG #1735: row number -1 is out of range 0..-1 error

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Bobi Ivanov <bobi(at)exsisto(dot)com>
Cc: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1735: row number -1 is out of range 0..-1 error
Date: 2005-07-01 13:35:16
Message-ID: 20050701133516.GA6524@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Jun 30, 2005 at 06:03:09PM +0300, Bobi Ivanov wrote:
>
> SELECT
> billingplans.id AS plan_id,
> billingplans.description as plan_name
> FROM (billingplans inner join billingplans_lots
>  on billingplans.id = billingplans_lots.plan_id) inner join resellerlots
>   on billingplans_lots.lot_id = resellerlots.lotid
> WHERE resellerlots.lot_desc = 45678 and resellerlots.resellerid = 1000
> 
> and this is what I  get:
> 
> row number -1 is out of range 0..-1
> Total query runtime: 40 ms.
> Data retrieval runtime: 30 ms.
> 0 rows retrieved.
> 
> I checked this through psql and:
> 
> plan_id | plan_name
> ---------+-----------
> (0 rows)

I get the same result (zero rows) in psql; that appears to be
correct, given the join conditions and the WHERE clause.  Maybe
Andreas or somebody else can test the query with pgAdmin.

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

In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2005-07-01 14:13:26
Subject: Re: BUG #1735: row number -1 is out of range 0..-1 error
Previous:From: karthikaDate: 2005-07-01 11:20:47
Subject: BUG #1743: problem in pg_restore

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