Re: prefer (+) oracle notation

Agreed.

> Tom Lane wrote:
> >
> > "Edmar Wiggers" <edmar(at)brasmap(dot)com> writes:
> > > I'm not sure about the standard, but I really like Oracle's notation for
> > > foreign keys:
> >
> > > select a.item_number, b.group_code_description
> > > from items a, group_codes b
> > > where a.group_code = b.group_code (+);
> >
> > I beg to differ --- IMHO, Oracle's notation is brain dead.
>
> I agree. In my opinion the best syntax for outer joins was brought up
> by informix. Ex:
>
> SELECT a.f1, b.f1, c.f1
> FROM a, OUTER( b, OUTER c )
> WHERE a.key = b.fkkey
> AND b.key = c.fkkey
>
> Where b is outer from a and c outer from b. Precedence and
> hierachical order is given by the parenthesis. Same example
>
> FROM a, OUTER ( b, c)
>
> b and c are outer from a. I find this syntax clear and logic without
> any danger of missinterpretation
>
> Best regards
> Herbie
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026