prefer (+) oracle notation
От | Edmar Wiggers |
---|---|
Тема | prefer (+) oracle notation |
Дата | |
Msg-id | NEBBIAKDCDHFGJMLHCKIKEHBCAAA.edmar@brasmap.com обсуждение исходный текст |
Ответ на | Re: (+) oracle notation ("Efrain Caro" <betsemes@hotmail.com>) |
Ответы |
Re: prefer (+) oracle notation
|
Список | 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.
В списке pgsql-general по дате отправления: