> It works for me:
> regression=# select t1.*, t2.* from t1 natural left outer join t2;
> id | id2 | id
> +-+
> 1 | 1 | 1
My recollection is that SQL9x requires that the join result lose the
link to the original table names. That is,
select id, id2 from t1 natural left outer
What version are you using? The sample code works for me
on current sources, three rows with the last one as 3|null|null
Stephan Szabo
[EMAIL PROTECTED]
On Fri, 15 Dec 2000 [EMAIL PROTECTED] wrote:
> Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the numbe
It works for me:
regression=# select t1.*, t2.* from t1 natural left outer join t2;
id | id2 | id
+-+
1 | 1 | 1
2 | 2 | 2
3 | |
(3 rows)
What version are you using?
regards, tom lane
Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Outer joins aren't working with views
Long Description
It seems outer joins are not working at all(they work as inner joins so far).
For example, see below:
(the re
