Received: from styx.apartia.int (postfix@r34m39.cybercable.tm.fr [195.132.34.39]) by hub.org (8.10.1/8.10.1) with ESMTP id e8KDQ6s33665 for ; Wed, 20 Sep 2000 09:26:06 -0400 (EDT) Received: by styx.apartia.int (Postfix, from userid 1000) id 56A274A32; Wed, 20 Sep 2000 15:25:52 +0200 (CEST) Date: Wed, 20 Sep 2000 15:25:52 +0200 From: Louis-David Mitterrand To: PGSQL-SQL Subject: ERROR: replace_vars_with_subplan_refs (!?) Message-ID: <20000920152552.A3958@styx> Reply-To: ldm@apartia.ch Mail-Followup-To: PGSQL-SQL References: <39C69B97.58B353A9@ec.gc.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <39C69B97.58B353A9@ec.gc.ca>; from bernie.huang@ec.gc.ca on Mon, Sep 18, 2000 at 03:47:51PM -0700 X-Archive-Number: 200009/147 How should I interpret that error? auction=# SELECT (select max(b.price) from bid b where b.auction_id = a.id and b.person_id = buyer.id) as last_lot,auction_status(a.id) > 0 AS current, a.lot, a.person_id, next_price(a.id), seller.mail AS seller_mail, buyer.mail AS buyer_mail, seller.locale AS seller_locale, buyer.login AS buyer_login, num_bid(a.id), seller.login AS seller_login, t.name AS auction_type FROM auction* a, person seller, person buyer, auction_type t WHERE a.id = 84 AND seller.id = a.person_id AND COALESCE(a.type,1) = t.id AND buyer.id = 2; ERROR: replace_vars_with_subplan_refs: variable not in subplan target list Thanks, -- Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org Marijuana is nature's way of saying, "Hi!".