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.