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 toselect * from t2 where id1 in (select t2.id1 from t1);
regards, tom lane