Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Fredrik Olsson
Fredrik Olsson wrote: Devrim GUNDUZ wrote: Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: snip 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? I'd start a new

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Mario Weilguni
Am Mittwoch, 23. November 2005 16:32 schrieb Pollard, Mike: If this gets added as a contrib, here's a version of uniqueidentifier and newid() I wrote that maintains the same format as the SQL Server version: CREATE SCHEMA sqlserver AUTHORIZATION postgres; GRANT ALL ON SCHEMA sqlserver TO

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Christopher Kings-Lynne
Why do you use GRANT ALL and not GRANT SELECT, UPDATE? All means everybody can do bad things with those sequences. GRANT ALL on a sequence IS GRANT SELECT UPDATE. Chris ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-24 Thread Pollard, Mike
, Mike; Bill Bartlett; Fredrik Olsson Subject: Re: [HACKERS] MS SQL Server compatibility functions Why do you use GRANT ALL and not GRANT SELECT, UPDATE? All means everybody can do bad things with those sequences. GRANT ALL on a sequence IS GRANT SELECT UPDATE. Chris

[HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Fredrik Olsson
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

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Bill Bartlett
I'd be _very_ interested. I'll also volunteer to help out on this if you need assistance -- we have somewhat of a mixed environment here, so I already have a few (simple) functions that allow some compatibility between MS SQL Server and PostgreSQL (supporting nextval on SQL Server, etc.), but it

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Pollard, Mike
Lincoln -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Bartlett Sent: Wednesday, November 23, 2005 10:01 AM To: 'Fredrik Olsson'; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] MS SQL Server compatibility functions I'd be _very_ interested. I'll

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Devrim GUNDUZ
Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: snip 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? I'd start a new project at pgfoundry and then would begin

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Fredrik Olsson
Devrim GUNDUZ wrote: Hi, On Wed, 23 Nov 2005, Fredrik Olsson wrote: snip 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? I'd start a new project at pgfoundry

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Christopher Kings-Lynne
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

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Pavel Stehule
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