Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 10C239FA02C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Dec 2006 02:57:15 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 08498-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Dec 2006 02:57:13 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nz-out-0102.google.com (nz-out-0506.google.com
 [64.233.162.238])
	by postgresql.org (Postfix) with ESMTP id 546C59F9F08
	for <pgsql-sql@postgresql.org>; Mon, 11 Dec 2006 02:57:14 -0400 (AST)
Received: by nz-out-0102.google.com with SMTP id i11so718400nzh
	for <pgsql-sql@postgresql.org>; Sun, 10 Dec 2006 22:57:11 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=o8533BkMeyiSeU7bxEe2LfeSmKVuenMuNEAZv06SnGjw3xNQmlpUDvG1YkahxP38acALil3Yh0Cd8cjrs3gcAH4zsq2WDZvhegtz12/3svNZ66jJI4gYDzd4rymekSEI1YVnQQQXRG4db9OLzS943evVDO/vQlG7ct1Vqzm1rEs=
Received: by 10.65.15.17 with SMTP id s17mr4607714qbi.1165820231511;
	Sun, 10 Dec 2006 22:57:11 -0800 (PST)
Received: by 10.65.206.18 with HTTP; Sun, 10 Dec 2006 22:57:11 -0800 (PST)
Message-ID: <bf54be870612102257l6ac34c94t568b228741c657f6@mail.gmail.com>
Date: Mon, 11 Dec 2006 11:57:11 +0500
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "Postgres SQL language list" <pgsql-sql@postgresql.org>
Subject: Re: subquery abnormal behavior
In-Reply-To: <bf54be870612102248j33f63ca1gd89e76d536a0262c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_55699_18609565.1165820231455"
References: <bf54be870612102248j33f63ca1gd89e76d536a0262c@mail.gmail.com>
X-Archive-Number: 200612/86
X-Sequence-Number: 27042

------=_Part_55699_18609565.1165820231455
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I just noticed the same behavior in Oracle and SQL Server as well :)

Regards,
---------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/11/06, Shoaib Mir <shoaibmir@gmail.com> 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!
>
> Can someone please comment?
>
> Thank you,
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>

------=_Part_55699_18609565.1165820231455
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I just noticed the same behavior in Oracle and SQL Server as well :)<br><br>Regards,<br>---------<br>Shoaib Mir<br>EnterpriseDB (<a href="http://www.enterprisedb.com">www.enterprisedb.com</a>)<br><br><div><span class="gmail_quote">
On 12/11/06, <b class="gmail_sendername">Shoaib Mir</b> &lt;<a href="mailto:shoaibmir@gmail.com">shoaibmir@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I just noticed an abnormal behavior for the subquery:<br><br>
								create table myt1 (a numeric);<br>
create table myt2 (b numeric);<br>
<br>
select a from myt1 where a in (select a from myt2);<br>
<br>
This should be giving an error that column 'a' does not exist in myt2 but it runs with any error...<br>
<br>
I had been trying it on 8.2!<br><br>Can someone please comment?<br><br>Thank you,<br>-------------<br><span class="sg">Shoaib Mir<br>EnterpriseDB (<a href="http://www.enterprisedb.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
www.enterprisedb.com</a>)<br>

</span></blockquote></div><br>

------=_Part_55699_18609565.1165820231455--