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

> > 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?

SELECT *
FROM tab1, OUTER tab2, OUTER tab3
WHERE tab1.col1 = tab2.col2 AND
tab1.col3 = tab3.col3

My assumption is that you can't join tab2 to tab3 becaue tab2 is already
outer, but I don't know.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026