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