Re: Subselect strange behaviour - bug? - Mailing list pgsql-sql

Tom Lane wrote:
> Mario Splivalo <mario.splivalo@megafon.hr> 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);
>
>   
Huh, you're right. Appologies for the noise :)
   Mario