From: mlw <markw@mohawksoft.com>
To: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Oracle compatibility
Date: Mon, 11 Feb 2002 14:49:10 -0500
Message-ID: <3C682036.F27CC2EF@mohawksoft.com> (raw)
I don't know how hard it would be to do, but I have rewritten some
Oracle code to work on PostgreSQL. While rewriting a couple functions,
and the tedium of changing SYSDATE to CURRDATE were a pain, these things
can be handled with a scripting language. The big problem, which means
that PostgreSQL code does not go back to Oracle, is the "join" syntax.
If there was a way to adopt the Oracle join syntax in addition to the
standard join syntax. It would make a great deal of difference. The
tedium of formatting and variable naming can be done by almost anyone.
The rewriting of complex queries into a completely different logical
syntax, can only be done by a knowledgeable person and a good QA team.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: markw@mohawksoft.com
Subject: Re: Oracle compatibility
In-Reply-To: <3C682036.F27CC2EF@mohawksoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox