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

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

pgsql-general by date:

Previous
From: "James Harper"
Date:
Subject: Re: old style outer joins
Next
From: "Daniel Verite"
Date:
Subject: Re: Number format problem