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
sszabo@bigpanda.com
On Fri, 15 Dec 2000 pgsql-bugs@postgresql.org wrote:
> Grzegorz Mucha (mucher@tigana.pl) 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 result is identical for inner and outer join) - two rows fetched from db(as I recall, there should be one more
rowhaving t1.id=3)
>
> Sample Code
> create table t1(id serial primary key);
> create table t2(id2 serial primary key, id int);
> insert into t1 values (1);
> insert into t1 values (2);
> insert into t1 values (3);
> insert into t2 (id) values(1);
> insert into t2 (id) values(2);
> select t1.*, t2.* from t1 natural left outer join t2;
>
> No file was uploaded with this report
>