Tom Lane wrote:
> Mario Splivalo <mario(dot)splivalo(at)megafon(dot)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