Re: old style outer joins

From: Richard Huxton <dev(at)archonet(dot)com>
To: James Harper <james(dot)harper(at)bendigoit(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: old style outer joins
Date: 2006-02-06 11:10:13
Message-ID: 43E72E95.4020900@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2006-02-06 11:15:52 Re: Number format problem
Previous Message James Harper 2006-02-06 11:09:30 Re: old style outer joins