Re: old style outer joins - Mailing list pgsql-general

From James Harper
Subject Re: old style outer joins
Date
Msg-id AEC6C66638C05B468B556EA548C1A77DAF0766@trantor
Whole thread Raw
In response to old style outer joins  ("James Harper" <james.harper@bendigoit.com.au>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: old style outer joins
Next
From: Richard Huxton
Date:
Subject: Re: old style outer joins