On Mon, Jun 29, 2009 at 5:11 PM, Scott Marlowe<scott.marlowe@xxxxxxxxx> wrote: > On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense<littlesuspense@xxxxxx> wrote: >> Hi Volk, >> >> at first sorry for my English. I use postgresql very often and I really >> love it but the syntax for outer join make me sick. >> Oracle short notation (+) is also not a best choice at this place but I >> recall me, that the Informix have a really good and clear syntax: > > Note that the word outer is just noise in pgsql, i.e. it's not needed. > What you've got are left outer, right outer, and full outer joins. > All can be called just left, right, or full joins. Note that inner > joins are just called joins. > >> select * from a, outer b where a.id = b.id; > > select * from a full join b on (a.id=b.id) where ... > select * from a left join b on (a.id=b.id) where ... > select * from a join b on (a.id=b.id) where ... also, select * from a join b using(id) where...; In simple join cases this is usually the best way to go. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
