Kevin Duffy wrote:
Hello:
I am starting a project using Postgres. The requirements are very similar to work I have done in the past using M$-SQL. Therefore, there are many Transact SQL stored procedures I need to port over to PL/pgSQL.
Where would I find documentation on PL/pgSQL, with examples?
How close to Oracle PL-SQL is Postgres? Would a Oracle PL-SQL book cover the basics?
Oracle PL-SQL and PL/pgSQL seem very similar. There are definitely differences however. Most of what you want to know is included in the PostgreSQL document. I'd recommend reading through the PL/pgSQL chapter several times before you begin.
_PostgreSQL_ by Douglas and Douglas has a chapter on PL/pgSQL. I'm not sure what that chapter is like as I don't own this book. It might be worth looking into.
I don't know of any documents that give hints for porting from TSQL to PL/pgSQL, but then I've not looked for any. They may exist.
Best of luck,
Dennis Sacks
dennis@illusions.com