Re: [GENERAL] Porting SQL Server 2000 database to PostgreSQL

2004-05-21 Thread anony
1. stored procedures are now called functions 2. unlike ms tsql, in postgres query analyzer you can't test conditional statements and variables outside of a function. this makes debugging really hard. 3. inside the function single quotes must be escaped because your function is entered in as a st

Re: [GENERAL] Porting SQL Server 2000 database to PostgreSQL

2004-05-21 Thread Richard Huxton
Rod Early wrote: I have the task of converting a SQL Server 2000 database to PostgreSQL. The data itself does not need to be converted, but the structure and stored procedures must be. I expect that converting tables and views will be simple. I expect that converting stored procedures and user-de