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 <[EMAIL PROTECTED]>
To: Fredrik Olsson <[EMAIL PROTECTED]>
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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
