subquery abnormal behavior

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Postgres SQL language list" <pgsql-sql(at)postgresql(dot)org>
Subject: subquery abnormal behavior
Date: 2006-12-11 06:48:03
Message-ID: bf54be870612102248j33f63ca1gd89e76d536a0262c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2006-12-11 06:51:59 Re: subquery abnormal behavior
Previous Message Aaron Bono 2006-12-08 14:09:10 Re: [HACKERS] Case Preservation disregarding case