Hi all!
I was asked to make a conversion from T-SQL (MSSQL) Procedure to PL/PGSQL. Regarding how boring is this task, the follow link helped me:
http://www.sqlines.com/online
I highly recommend it. The site has a commercial solution to convert all database, but some code can be converted online for free. 🙂
The conversion not fixed at all, but make a good part of the work… And all help is helpful…
There are lots of differences that I had to adjust manually, like
– Temporary tables
– Column aliases
– String manipulating functions
– “nolock” clauses
– Data types review in general
Those links helped to map correct syntax:
http://pgdocptbr.sourceforge.net/pg80/plpgsql-mssql.html
http://www.postgresql.org/docs/9.5/static/functions-string.html
http://www.postgresql.org/docs/9.5/static/datatype.html
Good luck!
Matheus.