Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL

"Ansley, Michael" wrote:
>
> >> > Yes, OUTER is an Informix-ism. Oracle uses *=. I think the first is
> >> > easier to add and makes more sense for us. *= could be defined by
> >> > someone as an operator, and overloading our already complex operator
> >> > code to do *= for OUTER may be too complex for people to understand.
> >> >
> >> > It would be:
> >> >
> >> > SELECT *
> >> > FROM tab1, OUTER tab2
> >> > WHERE tab1.col1 = tab2.col2
> >>
> >> What about >2 table joins? Wish I had my book here, but I though tyou
> >> could do multiple OUTER joins, no?
>
> Oracle uses a syntax which I quite like. The query above would become:
>
> SELECT *
> FROM tab, tab2
> WHERE tab1.col1 = tab2.col2 (+)
>
> I've actually used queries something like this:
>
> SELECT blah, blah, blah
> FROM t1, t2, t3, t4
> WHERE t1.start_date BETWEEN t2.start_date (+) AND t2.end_date (+)
> AND t1.y = t2.y (+)
> AND t3.x (+) = t1.x
> AND t3.y (+) = t1.y
> AND t4.x = t1.x;
>
> For example...
>
> I realise that this is not standard, but it's easy to read, and easy to
> develop.

I completely agree that Oracle has got it in a very clear, readable and
understandable way.

When I used MS Access (supposedly ANSI) I always created the outer join
queries
using the graphical tool and also had to examine it using said tool, because
all
these LEFT OUTER JOIN ON .... introduced too much line noise for me to be able
to understand what was actually meant.

OTOH, just marking the "outer" side with (+) was easy both to to read and
write.

So I would very much like to have the Oracle syntax for outer joins as well.

IMHO the ANSI standard (as anything designed by a committee) is not always the
best
way to do things.

--------------
Hannu