Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1CM6hx76922 for ; Mon, 12 Feb 2001 17:06:43 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id RAA27860; Mon, 12 Feb 2001 17:06:35 -0500 (EST) From: Bruce Momjian Message-Id: <200102122206.RAA27860@candle.pha.pa.us> Subject: Re: PL/PGSQL Cook Book In-Reply-To: "from Peter Eisentraut at Feb 12, 2001 11:11:45 pm" To: Peter Eisentraut Date: Mon, 12 Feb 2001 17:06:35 -0500 (EST) CC: mark proctor , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200102/236 X-Sequence-Number: 1427 Even a PL/PgSQL FAQ would be good. > 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@postgresql.org. 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@gmx.net http://yi.org/peter-e/ > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026