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
- [BUGS] Outer joins aren't working with views pgsql-bugs
- Re: [BUGS] Outer joins aren't working with views Stephan Szabo
- Re: [BUGS] Outer joins aren't working with views Tom Lane
- Re: [BUGS] Outer joins aren't working with views Thomas Lockhart