Forum OpenACS Development: PL/SQL-to-PL/PgSQL-HOWTO beta
Take a peek at http://www.brasileiro.net/roberto/howto/index.html and let me know what you think. I haven't had time to come up with a good example on how to port packages, so if you have one, please send it to me and I'll include it.
The HOWTO includes three instr functions that mimick Oracle's counterpart (they can be handy). Two of them are in PL/PgSQL and one of them in PL/Tcl, which I intend to port to PL/PgSQL sometime (though that'll be nasty).
guide ROCK. this is the best intro to pl/pgsql i've seen. thanks
It's worth to note that all those docs have been merged into the PostgreSQL official documentation (for 7.1).