Martijn Beelen (martijn(at)connectux(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Left Join/Outer Join
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...
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
|Next:||From: Tom Lane||Date: 2001-08-21 14:25:48|
|Subject: Re: Left Join/Outer Join |
|Previous:||From: Tom Lane||Date: 2001-08-21 02:11:58|
|Subject: Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields |