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
