Tom Lane wrote:
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);
Huh, you're right. Appologies for the noise :)
Mario
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
