Re: Oracle outer join syntax - Mailing list pgsql-general

From Simon Riggs
Subject Re: Oracle outer join syntax
Date
Msg-id 1144271363.13549.740.camel@localhost.localdomain
Whole thread Raw
In response to Re: Oracle outer join syntax  (Neil Conway <neilc@samurai.com>)
List pgsql-general
On Wed, 2006-04-05 at 12:19 -0400, Neil Conway wrote:
> On Wed, 2006-04-05 at 14:46 +0200, Stefan Nobis wrote:
> > Is there any way (or working solution) to extend PostgreSQL to accept
> > Oracles outer join syntax with '(+)'?
>
> Not AFAIK, and there are no plans to add support that I'm aware of.
> EnterpriseDB claim to have pretty good Oracle compatibility, so I'd
> imagine they support this syntax, although their online documentation
> doesn't mention it -- www.enterprisedb.com

Yes, EnterpriseDB supports this syntax and other similar Oracle-isms, as
well as full PostgreSQL/ANSI syntax.

This type of compatibility is aimed specifically at those people who
want to greatly reduce the cost of migrating application code from
Oracle to PostgreSQL.

Best Regards, Simon Riggs





pgsql-general by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: Migrating data from Oracle 9i to PostgreSQL
Next
From: Stefan Nobis
Date:
Subject: Re: Oracle outer join syntax