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, Pennsylvania 19026