Thread: [Fwd: MS SQL compatible functions]
Hi everyone,
Dean here seems to be converting to PostgreSQL from MS SQL Server, and I
have *no* idea how to help him out.
He's not on the list, so if anyone's got suggestions, please remember to
keep him in the To/CC list.
:-)
Regards and best wishes,
Justin Clift
-------- Original Message --------
Subject: MS SQL compatible functions
Date: Wed, 6 Feb 2002 18:17:13 +0800
From: "Dean Lu" <dean@tmdt.com.tw>
To: <justin@postgresql.org>
Dear Justin,
My name is Dean Lu, I am working in a SI company in Taiwan, we are
going to change our products to support the PostgreSQL and drop the MS
SQL away, but I got some problems with the functions compatibility
between MS and pgSQL. Could you please give me some suggestions or tell
me where can I get the functions from Internet. It will be better if
those functions are written in C language. Thank you very much.
Best Regards'
Dean Lu
This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In
fact,I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were
talkingto MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would
convert!
In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-create
yourdb. Your app will have to be re-written to some degree as well.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org
>>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>>
Hi everyone,
Dean here seems to be converting to PostgreSQL from MS SQL Server, and I
have *no* idea how to help him out.
He's not on the list, so if anyone's got suggestions, please remember to
keep him in the To/CC list.
:-)
Regards and best wishes,
Justin Clift
-------- Original Message --------
Subject: MS SQL compatible functions
Date: Wed, 6 Feb 2002 18:17:13 +0800
From: "Dean Lu" <>
To: <justin@postgresql.org>
Dear Justin,
My name is Dean Lu, I am working in a SI company in Taiwan, we are
going to change our products to support the PostgreSQL and drop the MS
SQL away, but I got some problems with the functions compatibility
between MS and pgSQL. Could you please give me some suggestions or tell
me where can I get the functions from Internet. It will be better if
those functions are written in C language. Thank you very much.
Best Regards'
Dean Lu
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
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? :-) Regards and best wishes, Justin Clift Ian Harding wrote: > > This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In fact,I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were talkingto MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would convert! > > In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-createyour db. Your app will have to be re-written to some degree as well. > > Ian A. Harding > Programmer/Analyst II > Tacoma-Pierce County Health Department > (253) 798-3549 > mailto: iharding@tpchd.org > > >>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>> > Hi everyone, > > Dean here seems to be converting to PostgreSQL from MS SQL Server, and I > have *no* idea how to help him out. > > He's not on the list, so if anyone's got suggestions, please remember to > keep him in the To/CC list. > > :-) > > Regards and best wishes, > > Justin Clift > > -------- Original Message -------- > Subject: MS SQL compatible functions > Date: Wed, 6 Feb 2002 18:17:13 +0800 > From: "Dean Lu" <> > To: <justin@postgresql.org> > > Dear Justin, > My name is Dean Lu, I am working in a SI company in Taiwan, we are > going to change our products to support the PostgreSQL and drop the MS > SQL away, but I got some problems with the functions compatibility > between MS and pgSQL. Could you please give me some suggestions or tell > me where can I get the functions from Internet. It will be better if > those functions are written in C language. Thank you very much. > > Best Regards' > Dean Lu > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
I think that kind of effort can be spent inceasing PG's capabilities. What percentage of people who have MS are going to shift to PG. The MS customer base is usually not the Linux/PG/GNU type. So who are we trying to please. Those who buy MS are buying it for commercial, finnancial, staffing and all the bean counting reasons. Those decisions are made by non-techies. So now you going to present to some IT Director who used to answer phones, your adapter layer. And the first question you'll get is "So does that mean I can still call my 800-microsoft-help-me for support". The second one is what is Linux? Let them be.... 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? > > :-) > > Regards and best wishes, > > Justin Clift > > Ian Harding wrote: > > > > This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In fact,I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were talkingto MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would convert! > > > > In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-createyour db. Your app will have to be re-written to some degree as well. > > > > Ian A. Harding > > Programmer/Analyst II > > Tacoma-Pierce County Health Department > > (253) 798-3549 > > mailto: iharding@tpchd.org > > > > >>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>> > > Hi everyone, > > > > Dean here seems to be converting to PostgreSQL from MS SQL Server, and I > > have *no* idea how to help him out. > > > > He's not on the list, so if anyone's got suggestions, please remember to > > keep him in the To/CC list. > > > > :-) > > > > Regards and best wishes, > > > > Justin Clift > > > > -------- Original Message -------- > > Subject: MS SQL compatible functions > > Date: Wed, 6 Feb 2002 18:17:13 +0800 > > From: "Dean Lu" <> > > To: <justin@postgresql.org> > > > > Dear Justin, > > My name is Dean Lu, I am working in a SI company in Taiwan, we are > > going to change our products to support the PostgreSQL and drop the MS > > SQL away, but I got some problems with the functions compatibility > > between MS and pgSQL. Could you please give me some suggestions or tell > > me where can I get the functions from Internet. It will be better if > > those functions are written in C language. Thank you very much. > > > > Best Regards' > > Dean Lu > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > -- > "My grandfather once told me that there are two kinds of people: those > who work and those who take the credit. He told me to try to be in the > first group; there was less competition there." > - Indira Gandhi > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- ------------------------------------------------------------------------- Medi Montaseri medi@CyberShell.com Unix Distributed Systems Engineer HTTP://www.CyberShell.com CyberShell Engineering -------------------------------------------------------------------------
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
I dunno... you could also get the type of people that have built (or inherited) a pre-existing application written in Oracle/SQLServer/etc that no longer want to pay the license fees and would like to switch to PostgreSQL, but aren't looking (or don't have the time right now) to convert their entire application... having that abstraction layer makes it that much easier for them to make the switch... -philip On Wed, 6 Feb 2002, Medi Montaseri wrote: > I think that kind of effort can be spent inceasing PG's capabilities. > What percentage of people who have MS are going to shift to PG. > The MS customer base is usually not the Linux/PG/GNU type. So > who are we trying to please. Those who buy MS are buying it for > commercial, finnancial, staffing and all the bean counting reasons. > Those decisions are made by non-techies. So now you going to > present to some IT Director who used to answer phones, your adapter > layer. And the first question you'll get is "So does that mean I can still > call my 800-microsoft-help-me for support". The second one is what is > Linux? > > Let them be.... > > 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? > > > > :-) > > > > Regards and best wishes, > > > > Justin Clift > > > > Ian Harding wrote: > > > > > > This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. Infact, I have been fantasizing about a compatibility module that would allow SQL Server applications to think they weretalking to MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would convert! > > > > > > In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-createyour db. Your app will have to be re-written to some degree as well. > > > > > > Ian A. Harding > > > Programmer/Analyst II > > > Tacoma-Pierce County Health Department > > > (253) 798-3549 > > > mailto: iharding@tpchd.org > > > > > > >>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>> > > > Hi everyone, > > > > > > Dean here seems to be converting to PostgreSQL from MS SQL Server, and I > > > have *no* idea how to help him out. > > > > > > He's not on the list, so if anyone's got suggestions, please remember to > > > keep him in the To/CC list. > > > > > > :-) > > > > > > Regards and best wishes, > > > > > > Justin Clift > > > > > > -------- Original Message -------- > > > Subject: MS SQL compatible functions > > > Date: Wed, 6 Feb 2002 18:17:13 +0800 > > > From: "Dean Lu" <> > > > To: <justin@postgresql.org> > > > > > > Dear Justin, > > > My name is Dean Lu, I am working in a SI company in Taiwan, we are > > > going to change our products to support the PostgreSQL and drop the MS > > > SQL away, but I got some problems with the functions compatibility > > > between MS and pgSQL. Could you please give me some suggestions or tell > > > me where can I get the functions from Internet. It will be better if > > > those functions are written in C language. Thank you very much. > > > > > > Best Regards' > > > Dean Lu > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > -- > > "My grandfather once told me that there are two kinds of people: those > > who work and those who take the credit. He told me to try to be in the > > first group; there was less competition there." > > - Indira Gandhi > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > -- > ------------------------------------------------------------------------- > Medi Montaseri medi@CyberShell.com > Unix Distributed Systems Engineer HTTP://www.CyberShell.com > CyberShell Engineering > ------------------------------------------------------------------------- > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
Philip Hallstrom wrote: > I dunno... you could also get the type of people that have built (or > inherited) a pre-existing application written in Oracle/SQLServer/etc that > no longer want to pay the license fees and would like to switch to > PostgreSQL, but aren't looking (or don't have the time right now) to > convert their entire application... having that abstraction layer makes it > that much easier for them to make the switch... Yes. No question about it. Our biggest problem is that it lacks _excitement_. :-) -- 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
Bruce Momjian wrote: > Philip Hallstrom wrote: > > I dunno... you could also get the type of people that have built (or > > inherited) a pre-existing application written in Oracle/SQLServer/etc that > > no longer want to pay the license fees and would like to switch to > > PostgreSQL, but aren't looking (or don't have the time right now) to > > convert their entire application... having that abstraction layer makes it > > that much easier for them to make the switch... > > Yes. No question about it. Our biggest problem is that it lacks > _excitement_. :-) > > -- > 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 Or it lacks priority.....on another thread a caller is asking for Distributed PG so he can install 20 linux boxes instead of an IBM 390 or Sun E10k PG and Ingress have always been more popular in the academic world, why not channel our energy in that area. Just imagine, a good distributed OS (linux), a good distributed DB (DPG) and a good distributed HTTP (apache, soap) and we have lift off. -- ------------------------------------------------------------------------- Medi Montaseri medi@CyberShell.com Unix Distributed Systems Engineer HTTP://www.CyberShell.com CyberShell Engineering -------------------------------------------------------------------------
> Or it lacks priority.....on another thread a caller is asking for Distributed > PG > so he can install 20 linux boxes instead of an IBM 390 or Sun E10k > > PG and Ingress have always been more popular in the academic world, why > not channel our energy in that area. Just imagine, a good distributed OS > (linux), > a good distributed DB (DPG) and a good distributed HTTP (apache, soap) and > we have lift off. No question is is important. It actually isn't the lack of excitement which is the problem, it is really the lack of challenge and the fact it is tedious to mimick another database. -- 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
Dear all,
Thanks for all of your advices and replied messages.
I've start to study how to write a function in pgSQL, not only for my company or myself.
also not for please anyone. That is only what I am going to do, I'll try it.
In Taiwan, most of the schools teach about MS series. So, we don't have the chance to touch
Linux as well, or I may say " We didn't smell it when we were students." I learnt Linux since
8 months ago, and meanwhile I found that's what I were looking for.
MS is a very big company and a very variant software's provider, they spent lots of money on
marketing and localization for expanding their customer base. We can't ignore what they done
successfully lock on their customers. So, I won't blame or hate anyone who were making
decision to buy MS stuff.
My company is a very small and young SI company, fortunately my boss is an open guy,
he agrees me that I am going to try to change the DB we used originally. In commercial
thinking, you may say that what I am doing is just wanted to keeping down the product cost.
But I have more expectancy on it.
"Linux", I can not make any definition on it cause I am just a beginner in this area, but if
by the rights of free speaking, I may say Linux is an open spirit, we have no enemy here in Linux.
No fights, no hates, no self conceit, no self reliant. Thus, I am not talking about business, I am
talking about we should make more people know the pgSQL is a fantasy DB. If some of SI
companies can join the pgSQL group. isn't it wonderful? If we build a freeway or a bridge between
them and pgSQL, isn't it wonderful?
I'd like to be one of the developers of pgSQL, but I know I am not qualify to do so, still I'll learn,
and hope I will be the one. My English is very poor but I've try so hard to read all the resources from
internet, and I need more resources about writing functions in C language, that's why I am here
and looking for some advices and helps from you masters.
Thanks for your help again.
Best Regards'
Dean Lu
-----Original Message-----
From: medi@mail.tmdt.com.tw [mailto:medi@mail.tmdt.com.tw]On Behalf Of Medi Montaseri
Sent: Thursday, February 07, 2002 9:45 AM
To: Justin Clift
Cc: Ian Harding; PostgreSQL Hackers Mailing List; pgsql-general@postgresql.org; dean@tmdt.com.tw
Subject: Re: [GENERAL] [Fwd: MS SQL compatible functions]
I think that kind of effort can be spent inceasing PG's capabilities.
What percentage of people who have MS are going to shift to PG.
The MS customer base is usually not the Linux/PG/GNU type. So
who are we trying to please. Those who buy MS are buying it for
commercial, finnancial, staffing and all the bean counting reasons.
Those decisions are made by non-techies. So now you going to
present to some IT Director who used to answer phones, your adapter
layer. And the first question you'll get is "So does that mean I can still
call my 800-microsoft-help-me for support". The second one is what is
Linux?
Let them be....
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?
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> Ian Harding wrote:
> >
> > This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In
fact,I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were
talkingto MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would
convert!
> >
> > In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to
re-createyour db. Your app will have to be re-written to some degree as well.
> >
> > Ian A. Harding
> > Programmer/Analyst II
> > Tacoma-Pierce County Health Department
> > (253) 798-3549
> > mailto: iharding@tpchd.org
> >
> > >>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>>
> > Hi everyone,
> >
> > Dean here seems to be converting to PostgreSQL from MS SQL Server, and I
> > have *no* idea how to help him out.
> >
> > He's not on the list, so if anyone's got suggestions, please remember to
> > keep him in the To/CC list.
> >
> > :-)
> >
> > Regards and best wishes,
> >
> > Justin Clift
> >
> > -------- Original Message --------
> > Subject: MS SQL compatible functions
> > Date: Wed, 6 Feb 2002 18:17:13 +0800
> > From: "Dean Lu" <>
> > To: <justin@postgresql.org>
> >
> > Dear Justin,
> > My name is Dean Lu, I am working in a SI company in Taiwan, we are
> > going to change our products to support the PostgreSQL and drop the MS
> > SQL away, but I got some problems with the functions compatibility
> > between MS and pgSQL. Could you please give me some suggestions or tell
> > me where can I get the functions from Internet. It will be better if
> > those functions are written in C language. Thank you very much.
> >
> > Best Regards'
> > Dean Lu
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
-------------------------------------------------------------------------
Medi Montaseri medi@CyberShell.com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------
Hi Justin, Just saw this on the newsgroup. I think it would be interesting to do some gap analysis (apologies for the management talk) that identified what could be done in MSSql server that cannot be done in postgres and use that to: a: provide functional comparison material to allow people to make a more informed decision when selecting there db. b. drive out potential projects to aid and encourage migration. I probably won't have much time to get involved in this over the next coiuple of months but may be able to get involved later. any thoughts? regards steve ----- Original Message ----- From: "Justin Clift" <justin@postgresql.org> To: "Ian Harding" <ianh@tpchd.org>; "PostgreSQL Hackers Mailing List" <pgsql-hackers@postgresql.org> Cc: <pgsql-general@postgresql.org>; <dean@tmdt.com.tw> Sent: Wednesday, February 06, 2002 11:42 PM Subject: Re: [GENERAL] [Fwd: MS SQL compatible functions] > 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? > > :-) > > Regards and best wishes, > > Justin Clift > > > Ian Harding wrote: > > > > This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In fact, I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were talking to MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would convert! > > > > In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-create your db. Your app will have to be re-written to some degree as well. > > > > Ian A. Harding > > Programmer/Analyst II > > Tacoma-Pierce County Health Department > > (253) 798-3549 > > mailto: iharding@tpchd.org > > > > >>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>> > > Hi everyone, > > > > Dean here seems to be converting to PostgreSQL from MS SQL Server, and I > > have *no* idea how to help him out. > > > > He's not on the list, so if anyone's got suggestions, please remember to > > keep him in the To/CC list. > > > > :-) > > > > Regards and best wishes, > > > > Justin Clift > > > > -------- Original Message -------- > > Subject: MS SQL compatible functions > > Date: Wed, 6 Feb 2002 18:17:13 +0800 > > From: "Dean Lu" <> > > To: <justin@postgresql.org> > > > > Dear Justin, > > My name is Dean Lu, I am working in a SI company in Taiwan, we are > > going to change our products to support the PostgreSQL and drop the MS > > SQL away, but I got some problems with the functions compatibility > > between MS and pgSQL. Could you please give me some suggestions or tell > > me where can I get the functions from Internet. It will be better if > > those functions are written in C language. Thank you very much. > > > > Best Regards' > > Dean Lu > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > -- > "My grandfather once told me that there are two kinds of people: those > who work and those who take the credit. He told me to try to be in the > first group; there was less competition there." > - Indira Gandhi > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >