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

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'The Hermit Hacker'" <scrappy(at)hub(dot)org>
Cc: "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL
Date: 2000-01-12 17:20:46
Message-ID: 219F68D65015D011A8E000006F8590C603FDC1FC@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > 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, tab4), tab5,
OUTER tab6, OUTER (tab7, OUTER tab8) where ......

imho understandable syntax.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Robinson 2000-01-12 18:21:15 Copy from/to asymmetry
Previous Message Michael Meskes 2000-01-12 16:56:37 Re: [HACKERS] FETCH without FROM/IN