On Wed, 2006-08-02 at 14:32, Chris Hoover wrote: > Question, > > What is the difference between left join, and left outer join? > > I know the difference between inner and outer joins, but I was > thinking that left join == inner join. But from what I am now seeing, > it appears that PG is equating left join to left outer join. Is this > correct?
A left or right join IS an outer join, as is a full join. the outer is just syntactic sugar. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
