Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id DB1659FA02C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Dec 2006 02:48:06 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 00483-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Dec 2006 02:48:06 -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.234])
	by postgresql.org (Postfix) with ESMTP id 5B5A99F9F08
	for <pgsql-sql@postgresql.org>; Mon, 11 Dec 2006 02:48:06 -0400 (AST)
Received: by nz-out-0102.google.com with SMTP id i11so717671nzh
	for <pgsql-sql@postgresql.org>; Sun, 10 Dec 2006 22:48:03 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=IM4qCiitgUtMVDvxDpnIEA27roks4v6ae1j0ctIqT0dgQzWH/DrEX82ewV/WrDzku8st9ZWqzAZX7DnZT9ieH+XWFkg44SqV27LKr33ceq6EWWm5yH0+mbIcalKhDQZ3ErFeafPTykqLThdD2lhzYaF7h2C6GSXZvIvvb4w9CB8=
Received: by 10.65.250.11 with SMTP id c11mr10252011qbs.1165819683363;
	Sun, 10 Dec 2006 22:48:03 -0800 (PST)
Received: by 10.65.206.18 with HTTP; Sun, 10 Dec 2006 22:48:03 -0800 (PST)
Message-ID: <bf54be870612102248j33f63ca1gd89e76d536a0262c@mail.gmail.com>
Date: Mon, 11 Dec 2006 11:48:03 +0500
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "Postgres SQL language list" <pgsql-sql@postgresql.org>
Subject: subquery abnormal behavior
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_55579_20757900.1165819683328"
X-Archive-Number: 200612/84
X-Sequence-Number: 27040

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

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_55579_20757900.1165819683328
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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>Shoaib Mir<br>EnterpriseDB (<a href="http://www.enterprisedb.com">www.enterprisedb.com</a>)<br>

------=_Part_55579_20757900.1165819683328--