Forum OpenACS Q&A: Response to Postgres feature questions

Yep, 9i has that cool (and easy to use) compile natively feature which is a big win for stuff that's computationally expensive. AskTom has an interesting discussion around this (although it talks more about implicit vs explicit cursors, but I still found it interesting).