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 - sorr
> 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 does
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 s
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 optio
