From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | chriskl(at)familyhealth(dot)com(dot)au, fredrik(dot)olsson(at)treyst(dot)se |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: MS SQL Server compatibility functions |
Date: | 2005-11-24 07:48:15 |
Message-ID: | BAY20-F205B15F9BD4CE704E767C0F9540@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
DB2, MySQL and MsSQL has shared group of function (date, time, strings). You
can do it a bit complex - use variable which direct behavior, but there
isn't bigger differences, I hope. Please (for start), use mycode, orafunc
from pgfoundry.
Regards
Pavel Stehule
>From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
>To: Fredrik Olsson <fredrik(dot)olsson(at)treyst(dot)se>
>CC: pgsql-hackers(at)postgresql(dot)org
>Subject: Re: [HACKERS] MS SQL Server compatibility functions
>Date: Thu, 24 Nov 2005 09:24:06 +0800
>
>I just started a MySQL compatibility functions project on pgfoundry.org. I
>suggest starting an MSSQL one as well. I'd be interested if you could mail
>me your code for your functions so far because many of the MySQL functions
>are copied from MSSQL...
>
>Chris
>
>Fredrik Olsson wrote:
>>Hi.
>>
>>In the course of porting a database from Microsoft SQL Server to
>>PostgreSQL I have rewritten a few of the date and string functions in
>>pl/pgSQL. Started with just datepart, datediff and soundex, but once
>>started I continued and rewrote all date/time and string functions
>>supported by MS SQL 2005. Leaving only compatibility with unicode-handling
>>and binary objects (that MS SQL Server for some reason overloads string
>>functions to work with).
>>
>>I guess I am not the only one moving from MS SQL Server, so is there
>>interest for others to use my work, as a contrib perhaps. And how should I
>>continue from here in that case?
>>
>>regards
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2005-11-24 08:00:20 | Re: core dump on 8.1 and no dump on REL8_1_STABLE |
Previous Message | Harald Armin Massa | 2005-11-24 07:25:15 | Re: Private email requests |