X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 4370AD1B4BE
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 14 Apr 2004 14:06:23 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 09545-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 14 Apr 2004 14:06:21 -0300 (ADT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.185])
	by svr1.postgresql.org (Postfix) with ESMTP id 5270ED1B49B
	for <pgsql-sql@postgresql.org>; Wed, 14 Apr 2004 14:06:20 -0300 (ADT)
Received: from [212.227.126.160] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1BDnq8-0007aW-00
	for pgsql-sql@postgresql.org; Wed, 14 Apr 2004 19:06:20 +0200
Received: from [217.84.207.49] (helo=curson.alpha.quadrant)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1BDnq8-0007Ic-00
	for pgsql-sql@postgresql.org; Wed, 14 Apr 2004 19:06:20 +0200
Received: from xinux.de (lorien.alpha.quadrant [192.168.254.21])
	by curson.alpha.quadrant (Postfix) with ESMTP id DB7E4274EB
	for <pgsql-sql@postgresql.org>; Wed, 14 Apr 2004 19:06:03 +0200 (CEST)
Message-ID: <407D6F75.8040804@xinux.de>
Date: Wed, 14 Apr 2004 19:05:57 +0200
From: Tina Messmann <tina.messmann@xinux.de>
User-Agent: Mozilla Thunderbird 0.5 (X11/20040208)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: full join...using and version of pgsql
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	auth:1b45b46ad067fa69390938eea860f251
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200404/128
X-Sequence-Number: 17503

hello list,

i am using pgsql 7.2.1
i need something like

select * from t1 full join t2 using(bla) full join t3 using(bla)

i searched the archives and found that this is not possible with my 
version of postgres.
is this implemented in newer versions of postgres? since which version?

i'll try the alternative select * from t1 full join t2 on(t1.bla=t2.bla) 
full join t3 on(t1/t2.bla=t3.bla)
but this is not the best solution for me i think....

regards
tina