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

ERROR: replace_vars_with_subplan_refs (!?)

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: ERROR: replace_vars_with_subplan_refs (!?)
Date: 2000-09-20 13:25:52
Message-ID: 20000920152552.A3958@styx (view raw or whole thread)
Lists: pgsql-sql
How should I interpret that error?

auction=# SELECT (select max(b.price) from bid b where b.auction_id = and b.person_id = as last_lot,auction_status( > 0 AS current, a.lot, a.person_id, next_price(, seller.mail AS seller_mail, buyer.mail AS buyer_mail, seller.locale AS seller_locale, buyer.login AS buyer_login, num_bid(, seller.login AS seller_login, AS auction_type FROM auction* a, person seller, person buyer, auction_type t WHERE = 84 AND = a.person_id AND COALESCE(a.type,1) = AND = 2;
ERROR:  replace_vars_with_subplan_refs: variable not in subplan target list


Louis-David Mitterrand - ldm(at)apartia(dot)org -

 Marijuana is nature's way of saying, "Hi!".

In response to

  • Division at 2000-09-18 22:47:51 from Bernie Huang


pgsql-sql by date

Next:From: Tom LaneDate: 2000-09-20 14:41:37
Subject: Re: no ORDER BY in subselects?
Previous:From: Louis-David MitterrandDate: 2000-09-20 13:23:04
Subject: no ORDER BY in subselects?

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