Forum OpenACS Q&A: Contribute to the PL/pgSQL CookBook

Posted by Roberto Mello on
I have started the "PL/pgSQL CookBook" project. The goal is to create a cookbook of PL/pgSQL functions that will be catalogued and made available for others to use and learn from.

Come to and contribute your own PL/pgSQL (or PL/Tcl, PL/Perl) function or trigger! This will help many Postgres users, both novice and experienced, to use its procedural languages.

The CookBook has several sections, and you can add your own. No login is required, just come and contribute.

Once again

Oh, did I mention that you get your own "PostgreSQL Powered" button when you contribute a function/trigger? :)


Posted by Don Baccus on
This is a cool idea, Roberto.  Months ago when I was particularly peeved at the PG webmaster types a friend and I started to put together an alternative site for PG.  I calmed down and decided not to, but your cookbook idea displays the kind of insight into the kinds of things a good project support site might contain.  The PG webmaster  types seem to think that all they need are static pages and mailing list archives that as often as not are weeks out of date.
Thanks Don. I agree wholeheartedly with you that the PG website could use some community features, such as the ones OpenACS provides, plus a few more (like the CookBook).

I just finished the revamping of the PL/pgSQL documentation. IMHO it's much much better than the current docs. It has a coherent structure, more subsections, many more examples, more explanations, etc.

I submitted to the PG team and it should be incorporated in PG 7.1. You can look at them now at

Posted by Jerry Asher on
Roberto, your cookbook looks wonderful, and I wish it great success.  (Perhaps it could be illustrated.... maybe there's a tie-in between you and the c-cup cafe?)

Don, I agree entirely.  When I started looking at the PG website a few weeks ago, I was somewhat shocked/amused that it's a static site with no dynamic database backed features at all.