Re: Trouble with strange OUTER JOIN syntax

Farid Hajji <farid.hajji@ob.kamp.net> writes:
> How would you translate the following SELECT statements with
> outer joins to PostgreSQL syntax?

> SELECT ...
>   FROM tab1 alias_tab1, tab2 alias_tab2,
>        OUTER ot1 alias_ot1,
>        OUTER ot2 alias_ot2
>   WHERE ...

> SELECT
>   FROM tab1 alias_tab1, tab2 alias_tab2,
>        OUTER (ot1 alias_ot1, ot2 alias_ot2)
>   WHERE ...

Tell me what that means, and I'll tell you how to translate it.
What is being joined to what, on what keys, and which side is
allowed to become null in the join?

            regards, tom lane