Left Join/Outer Join

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Left Join/Outer Join
Дата
Msg-id 200108211325.f7LDPwE99759@hub.org
обсуждение исходный текст
Ответы Re: Left Join/Outer Join  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Left Join/Outer Join  (Bruno Wolff III <bruno@wolff.to>)
Re: Left Join/Outer Join  (grant <grant@amadensor.com>)
Список pgsql-bugs
Martijn Beelen (martijn@connectux.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Left Join/Outer Join

Long Description
When using left join, I get the errormessage
"ERROR: OUTER JOIN is not yet supported"

I hope left-joins are supported, if not, at least the errormessage seems awkward...

Also, the use of extra parenthesis seems to make the interpreter get confused. When I put some extra parenthesis around
astatement, I get parse errors... 

Martijn Beelen

Sample Code
select * from (table1 left join table2 on table1.id = table2.id);
ERROR: OUTER JOIN is not yet supported

select * from ((table1 left join table2 on table1.id = table2.id));
ERROR: parser: parse error at or near "("


No file was uploaded with this report

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Left Join/Outer Join