pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mark proctor <m.proctor@bigfoot.com>
To: pgsql-sql@postgresql.org
Subject: PL/PGSQL Cook Book
Date: Fri, 9 Feb 2001 12:02:33 +0000
Message-ID: <01020912023303.04458@localhost.localdomain> (raw)
In-Reply-To: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net>
References: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net>

I've just spent the last day or two trying to get to grips with plpgsql and can't believe how abysmal the documetentation and examples are.
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.

Here are some possible sections to help get people thinking. Even if you don't know the answer send me the questions and I'll add them to the list.
   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

Anyway lets discuss this, a lot could be done just from piecing together relavent tips from this mailing list.
ie there are some good posts on tree structures, which if I'm willing to piece together if people think this project is worth while.

Regards

Mark




view thread (6+ messages)  latest in thread

Message-ID: <01020912023303.04458@localhost.localdomain>
Permalink:  ../01020912023303.04458@localhost.localdomain/
Also on:    postgresql.org/message-id/01020912023303.04458@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: m.proctor@bigfoot.com
  Subject: Re: PL/PGSQL Cook Book
  In-Reply-To: <01020912023303.04458@localhost.localdomain>
  References: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net> <01020912023303.04458@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox