From: Tina Messmann <tina.messmann@xinux.de>
To: pgsql-sql@postgresql.org
Subject: full join...using and version of pgsql
Date: Wed, 14 Apr 2004 19:05:57 +0200
Message-ID: <407D6F75.8040804@xinux.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tina.messmann@xinux.de
Subject: Re: full join...using and version of pgsql
In-Reply-To: <407D6F75.8040804@xinux.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox