Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C7CD22E002E for ; Sun, 16 Mar 2008 15:28:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 18565-02 for ; Sun, 16 Mar 2008 15:28:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C31262E005B for ; Sun, 16 Mar 2008 15:28:11 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2GIS8ig000431; Sun, 16 Mar 2008 14:28:08 -0400 (EDT) To: Mario Splivalo cc: pgsql-sql@postgresql.org Subject: Re: Subselect strange behaviour - bug? In-reply-to: <47DD5D3A.6060100@megafon.hr> References: <47DD5D3A.6060100@megafon.hr> Comments: In-reply-to Mario Splivalo message dated "Sun, 16 Mar 2008 18:47:38 +0100" Date: Sun, 16 Mar 2008 14:28:08 -0400 Message-ID: <430.1205692088@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/91 X-Sequence-Number: 30419 Mario Splivalo writes: > And here is the 'problematic' query: > melem=# select * from t2 where id1 in (select id1 from t1); > I guess postgres should tell me that column name id1 is nonexistant in > table t1. No, it shouldn't, because that's a perfectly legal outer reference; that is, what you wrote is equivalent to select * from t2 where id1 in (select t2.id1 from t1); regards, tom lane