full join...using and version of pgsql

From: Tina Messmann <tina(dot)messmann(at)xinux(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: full join...using and version of pgsql
Date: 2004-04-14 17:05:57
Message-ID: 407D6F75.8040804@xinux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2004-04-14 20:39:52 Re: full join...using and version of pgsql
Previous Message Tony and Bryn Reina 2004-04-14 15:54:14 Re: Help with COPY command