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/