| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Stefan Nobis <stefan-ml(at)snobis(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Oracle outer join syntax |
| Date: | 2006-04-05 21:09:23 |
| Message-ID: | 1144271363.13549.740.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Nobis | 2006-04-05 21:11:36 | Re: Oracle outer join syntax |
| Previous Message | Mikael Carneholm | 2006-04-05 20:57:24 | Re: Migrating data from Oracle 9i to PostgreSQL |