> On Mon, Feb 06, 2006 at 09:42:22PM +1100, James Harper wrote: > > I think the answer is no, but can anyone tell me if postgresql supports > > the older (pre sql-92?) style outer join syntax, eg: > > I think you're referring to some kind of non-standard > invented-by-oracle syntax. > > > It doesn't appear to support that exact syntax, which suggests it > > doesn't know what I'm talking about, but maybe there's a system option > > to turn it on??? > > PostgreSQL has never supported this, nor is likely to ever do so. > Does anyone else actually support that syntax? I known MSSQL does, and I was thinking that oracle did too, but then I remembered it was actually Sybase, which is the same as MSSQL. So yeah, sounds like an invented-by-someone syntax. Thanks James