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

> select ...
> from t1 inner join t4 on t1.x=t4.x,
>      t2 left outer join t1
>        on t2.y=t1.y and
>           (t1.start_date between t2.start_date and t1.start_date),
>      t3 left outer join t1 on t3.x=t1.x and t3.y = t1.y;

Let's be honest, folks.  This is almost unreadable.  I think we will
need some simpler way to access _outer_ in addition to the ANSI way.

I can't imagine how I would answer a question: "How do I do an ANSI
outer join".  It would need its own FAQ page.

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