Postgres Pro
Downloads
Home   >   mailing lists

Thread: old style outer joins

old style outer joins

From
"James Harper"
Date:
I think the answer is no, but can anyone tell me if postgresql supports
the older (pre sql-92?) style outer join syntax, eg:

SELECT *
FROM a,b
WHERE a.pk *= b.fk

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

Thanks

James

Re: old style outer joins

From
Martijn van Oosterhout
Date:
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?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
Attachment

Re: old style outer joins

From
"James Harper"
Date:
> 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

Re: old style outer joins

From
Richard Huxton
Date:
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:
>
> SELECT *
> FROM a,b
> WHERE a.pk *= b.fk

I don't think that was ever part of the SQL standard - just an
Oracle-ism. And no, PG doesn't support it - sorry.

--
   Richard Huxton
   Archonet Ltd