Re: PL/PGSQL Cook Book

mark proctor writes:

> I've been trawling through the mailist lists and I notice there was
> talk back in 1999 abouta PLPGSQL Cook Book - did anything come of
> this? If no one is maintaining something like this and people think
> its a good idea I think we should have another crack at it. I'd be
> happy to maintain something like this and put it up on the web,
> although I'm only a newbie and would rely upon user contribution.

Start writing, and send it to pgsql-docs(at)postgresql(dot)org(dot) It doesn't have
to be a great work of literature; incremental work is just fine.

> How can I create Tree structures?
> Are recursive functions supported?
> Whats are the advanteds disadvantes of the different scipting langues PL/PGSQL, PL/Perl, PL/Tcl?
> How do variable scopes work in PL/PGSQL?
> Can I output variables from a function to the command line for debugging purposes?
> How to debug PL/PGSQL?
> Various examples for each of the statements

All valid questions.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/