full join...using and version of pgsql - Mailing list pgsql-sql

From Tina Messmann
Subject full join...using and version of pgsql
Date
Msg-id 407D6F75.8040804@xinux.de
Whole thread Raw
Responses Re: full join...using and version of pgsql  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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



pgsql-sql by date:

Previous
From: "Tony and Bryn Reina"
Date:
Subject: Re: Help with COPY command
Next
From: "scott.marlowe"
Date:
Subject: Re: full join...using and version of pgsql