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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026