> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
