old style outer joins
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
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/
Show quoted text
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.
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
Import Notes
Resolved by subject fallback
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