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

> I've been wanting outer joins, but in my porting efforts have managed
> to work around them without too much difficulty, even though 6.5's
> limitations on subselects (not in target lists) requires that I
> create PL/pgSQL functions in some cases.
> 
> I certainly can't speak for the majority of users, but as one data
> point I'd personally rather see outer joins done right (SQL 92
> syntax) and wait a bit.
> 
> Then again, I tend to be a bit of a language purist...
> 

Thomas has tried to explain the ANSI syntax for outer joins, and I must
say I am quite confused by it.  A simple OUTER added before the column
name would be a quick and simple way to do outers, perhap get them into
7.0, and allow new users to do outers without having to learn the quite
complex ANSI syntax.

At least that was my idea.
--  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