Re: prefer (+) oracle notation

Excuse me,

I should have written :

I t seems to be ambiguous !!! too ...

Claudio.

Claudio Jose Zanardi Grillo wrote:

> Hi,
>
> The Sybase notation for outer joins seems to be good too:
>
> *=
> or
> =*
>
> Claudio
>
> Edmar Wiggers wrote:
>
> > 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 (+);
> >
> > Much better than
> >
> > select a.item_number, b.group_code_description
> > from items a outer join group_codes b on a.group_code = b.group_code;
> >
> > In fact, it's MUCH BETTER when you have to join several tables (one thing
> > PgSQL is very good at, by the way). In such cases, the seconde syntax
> > requires an unreadable lot of ()'s in the from clause.
> >
> > Don't mean to throw away the standard though, but having Oracle's (+) syntax
> > around too would be a big help.