| From: | mlw <markw(at)mohawksoft(dot)com> |
|---|---|
| To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Oracle compatibility |
| Date: | 2002-02-11 19:49:10 |
| Message-ID: | 3C682036.F27CC2EF@mohawksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-11 20:02:38 | Re: [HACKERS] Feature enhancement request : use of libgda |
| Previous Message | Jason Tishler | 2002-02-11 19:48:17 | Re: PostgreSQL 7.2 on Cygwin |