Re: MS SQL Server compatibility functions - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: MS SQL Server compatibility functions
Date
Msg-id BAY20-F205B15F9BD4CE704E767C0F9540@phx.gbl
Whole thread Raw
In response to Re: MS SQL Server compatibility functions  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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@familyhealth.com.au>
>To: Fredrik Olsson <fredrik.olsson@treyst.se>
>CC: pgsql-hackers@postgresql.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/



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: someone working to add merge?
Next
From: Teodor Sigaev
Date:
Subject: Re: core dump on 8.1 and no dump on REL8_1_STABLE