Re: subquery abnormal behavior - Mailing list pgsql-sql

I just noticed an abnormal behavior for the subquery:

create table myt1 (a numeric);
create table myt2 (b numeric);

select a from myt1 where a in (select a from myt2);

This should be giving an error that column 'a' does not exist in myt2 but it runs with any error...

I had been trying it on 8.2!

Can someone please comment?

Thank you,
-------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)