Mario Splivalo <[EMAIL PROTECTED]> 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
