Re: prefer (+) oracle notation

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: prefer (+) oracle notation
Дата
Msg-id 200010192326.TAA19413@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: prefer (+) oracle notation  (Herbert Liechti <Herbert.Liechti@thinx.ch>)
Список pgsql-general
Agreed.


> Tom Lane wrote:
> >
> > "Edmar Wiggers" <edmar@brasmap.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-general по дате отправления:

Предыдущее
От: "Edmar Wiggers"
Дата:
Сообщение: RE: prefer (+) oracle notation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: rules *very* slow?