Left Join/Outer Join - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Left Join/Outer Join
Date
Msg-id 200108211325.f7LDPwE99759@hub.org
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields
Next
From: Tom Lane
Date:
Subject: Re: Left Join/Outer Join