Re: [GENERAL] prefer (+) oracle notation

2000-10-19 Thread Herbert Liechti
Tom Lane wrote: > > "Edmar Wiggers" <[EMAIL PROTECTED]> 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_c

Re: [GENERAL] prefer (+) oracle notation

2000-10-19 Thread Tom Lane
"Edmar Wiggers" <[EMAIL PROTECTED]> 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 --- IMH

[GENERAL] prefer (+) oracle notation

2000-10-19 Thread Edmar Wiggers
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_descriptio