Re:

On Mon, Jun 29, 2009 at 5:11 PM, Scott Marlowe<scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense<littlesuspense(at)web(dot)de> 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