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

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Michael Fuhr
> Sent: 01 July 2005 14:35
> To: Bobi Ivanov
> Cc: Andreas Pflug; pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #1735: row number -1 is out of range
> 0..-1 error
>
> 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.

I get 0 rows and no errors with pgAdmin SVN trunk (not that we have
changed any of that code recently anyway).

Regards, Dave