Stored Procedures too PostgreSQL Functions
Stored Procedures too PostgreSQL Functions
(OP)
Hi all, I need translate some SQL server Stored Procedures into PostgreSQL Functions, how can I do this ?
Any help with this will be appretiated greatly.
Regards, Mark.
Any help with this will be appretiated greatly.
Regards, Mark.
RE: Stored Procedures too PostgreSQL Functions
Well....
By knowing how SQL Server's procedural language works, and by knowing how PostgreSQL's procedural language works, and then by creating PostgreSQL procedures that do the equivalent of the SQL Server procedures. Just like porting functions from any language into any other language, there's no secret to it, but there's no way around doing the hard work.
Spend some time at http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=programmer-pl.html and become familiar with Pl/PgSQL, which is PostgreSQL's primary procedural language. You might also want to start spending large amounts of time at http://techdocs.postgresql.org/.
-------------------------------------------
My PostgreSQL FAQ -- http://brainscraps.com/faq/pg_my.html