They're planning to add "server side scripting" in any language to replace stored procedures. It sounds quite cool.
http://krow.livejournal.com/638941.html
I have been writing extensions to Postgresql in C++ recently, and it's amazing what you can do if you have the full flexibility of loading a .so into the db process and doing whatever you want.