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)