prefer (+) oracle notation

From: "Edmar Wiggers" <edmar(at)brasmap(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: prefer (+) oracle notation
Date: 2000-10-19 20:17:53
Message-ID: NEBBIAKDCDHFGJMLHCKIKEHBCAAA.edmar@brasmap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2000-10-19 20:24:54 Re: Any risk in increasing BLCKSZ to get larger tuples?
Previous Message Joshua Adam Ginsberg 2000-10-19 19:37:23 Re: (+) oracle notation