On 12/11/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
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!
Even in 8.1.5 it does not complain. (its not 8.2 specific at least)
Regds
mallah.
Can someone please comment?
Thank you,
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
