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

=20

> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org=20
> [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Michael Fuhr
> Sent: 01 July 2005 14:35
> To: Bobi Ivanov
> Cc: Andreas Pflug; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1735: row number -1 is out of range=20
> 0..-1 error
>=20
> 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 =3D billingplans_lots.plan_id) inner join=20
> resellerlots
> >   on billingplans_lots.lot_id =3D resellerlots.lotid
> > WHERE resellerlots.lot_desc =3D 45678 and=20
> resellerlots.resellerid =3D 1000
> >=20
> > and this is what I  get:
> >=20
> > row number -1 is out of range 0..-1
> > Total query runtime: 40 ms.
> > Data retrieval runtime: 30 ms.
> > 0 rows retrieved.
> >=20
> > I checked this through psql and:
> >=20
> > plan_id | plan_name
> > ---------+-----------
> > (0 rows)
>=20
> 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