Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f22HIDx51865 for ; Fri, 2 Mar 2001 12:18:13 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f22HIA903939; Fri, 2 Mar 2001 12:18:10 -0500 (EST) To: Martin Lillepuu cc: pgsql-sql@postgresql.org Subject: Re: union & subqueries In-reply-to: <3A9FA353.EE681533@lillepuu.com> References: <3A9FA353.EE681533@lillepuu.com> Comments: In-reply-to Martin Lillepuu message dated "Fri, 02 Mar 2001 15:42:43 +0200" Date: Fri, 02 Mar 2001 12:18:10 -0500 Message-ID: <3936.983553490@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/29 X-Sequence-Number: 1674 Martin Lillepuu writes: > when I run following sql in 2 separate queries, they work fine. but when > used as one beg statement with UNION, I get following error: > join_references: variable not in subplan target lists AFAICT this works OK in 7.1beta. regards, tom lane