full join...using and version of pgsql

Поиск
Список
Период
Сортировка
От Tina Messmann
Тема full join...using and version of pgsql
Дата
Msg-id 407D6F75.8040804@xinux.de
обсуждение исходный текст
Ответы Re: full join...using and version of pgsql
Список 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 по дате отправления:

Предыдущее
От: "Tony and Bryn Reina"
Дата:
Сообщение: Re: Help with COPY command
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: full join...using and version of pgsql