Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37196=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UGPOZ-0004OG-PU
	for pgsql-sql@arkaria.postgresql.org; Fri, 15 Mar 2013 07:49:45 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37196=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UGPOY-0003tw-7l
	for pgsql-sql@arkaria.postgresql.org; Fri, 15 Mar 2013 07:49:42 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <achill@matrix.gatewaynet.com>) id 1UGPOX-0003tq-8t
	for pgsql-sql@postgresql.org; Fri, 15 Mar 2013 07:49:41 +0000
Received: from adsltrust.ath.forthnet.gr ([194.219.204.174]
	helo=smadev.internal.net)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <achill@matrix.gatewaynet.com>) id 1UGPOV-0002KL-Fc
	for pgsql-sql@postgresql.org; Fri, 15 Mar 2013 07:49:40 +0000
X-Bogosity: No, tests=bogofilter
Received: from smadev.internal.net (localhost [127.0.0.1])
	by smadev.internal.net (8.14.5/8.14.5) with ESMTP id r2F7naWk003155
	for <pgsql-sql@postgresql.org>; Fri, 15 Mar 2013 09:49:36 +0200 (EET)
	(envelope-from achill@matrix.gatewaynet.com)
Received: (from achill@localhost)
	by smadev.internal.net (8.14.5/8.14.5/Submit) id r2F7na9f003154
	for pgsql-sql@postgresql.org; Fri, 15 Mar 2013 09:49:36 +0200 (EET)
	(envelope-from achill@matrix.gatewaynet.com)
X-Authentication-Warning: smadev.internal.net: achill set sender to
	achill@matrix.gatewaynet.com using -f
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-sql@postgresql.org
Subject: Re: bug in 9.2.2 ? subquery accepts wrong column name : upd
Date: Fri, 15 Mar 2013 09:49:36 +0200
Message-ID: <1736496.2mMupsnC8K@smadev.internal.net>
Organization: Dynacom Tankers Mgmt
X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_;
	f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO`
	a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct}
	^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J
	Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR<BSn
User-Agent: KMail/4.8.4 (FreeBSD/8.3-RELEASE; KDE/4.8.4; amd64; ; )
In-Reply-To: <17320.1363277866@sss.pgh.pa.us>
References: <1641558.Xf5bk256pC@smadev.internal.net>
	<17320.1363277866@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Thanx Tom.

On =CE =CE=B5=CE=BC 14 =CE=9C=CE=B1=CF=81 2013 12:17:46 Tom Lane wrote:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> > dynacom=3D# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg[1:2] F=
ROM=20
> > 	(select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY sst=
.setid ORDER BY character_length(vsl.name))) as arragg=20
> > 	FROM sissets sst, vessels vsl WHERE vsl.id=3Dsst.vslid ORDER BY sst.se=
tid) as qry=20
> >      WHERE array_length(qry.arragg,1)>1  AND qry.setid IN (SELECT setid=
 from sis_oper_cons) ORDER BY qry.setid,array_length(qry.arragg,1);
> > [ works ]
>=20
> > however, there is not column setid in sis_oper_cons,
>=20
> If not, that's a perfectly legal outer reference to qry.setid.
>=20
> Probably not one of SQL's better design features, since it confuses
> people regularly; but it's required by spec to work like that.
>=20
> 			regards, tom lane
>=20
>=20
>=20
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql