Re: [HACKERS] [Fwd: MS SQL compatible functions]

Justin Clift wrote:
> Hi Ian,
>
> A compatibility has already been considered for Oracle, you're
> mentioning one for MS SQL Server.
>
> Maybe it's time to think about how an abstraction layer could be added,
> and then appropriate Oracle/Sybase/Informix/MSSQL/etc
> modules/plug-ins/layers could be added to that?
>
> Wonder how much work it would take?

It's on the TODO list and I am willing to outline the options anytime.

One way is to have SQL functions that can be run on a desired database
to CREATE FUNCTION various compatibility functions.  I think there are
some for ODBC and I can imagine others.

For syntax stuff, I think the cleanest way would be to have a parser run
_before_ the main parser, rewriting stuff into PostgreSQL syntax and
cleaning up issues.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026