Skip site navigation (1) Skip section navigation (2)

Left Join/Outer Join

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Left Join/Outer Join
Date: 2001-08-21 13:25:58
Message-ID: 200108211325.f7LDPwE99759@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Martijn Beelen (martijn(at)connectux(dot)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 a statement, 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


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-08-21 14:25:48
Subject: Re: Left Join/Outer Join
Previous:From: Tom LaneDate: 2001-08-21 02:11:58
Subject: Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group