Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: "Sandy Ear" <sear@la-rubber.com>, <pgsql-sql@postgresql.org>
Subject: Re: PLPGSQL language documentation
Date: Tue, 9 Jul 2002 10:11:36 -0700
References: <1582.10.1.1.39.1026168301.squirrel@www.la-rubber.com>
In-Reply-To: <1582.10.1.1.39.1026168301.squirrel@www.la-rubber.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200207091011.36349.josh@agliodbs.com>

Sandy,

> I was wondering if anyone knew of good online documentation on PlPgsql?

Read two things:

1. the online docs for PostgreSQL 7.2 under "Programmer's guide: Procedural=
=20
Languages"

2. Roberto' Mello's enhanced documentation, accessable through=20
techdocs.postgresql.org.  Roberto also has a PLpgSQL function library that=
=20
should give you some good examples.  However, this is entirely for Postgres=
=20
7.0 and 7.1, so there are some syntax changes in the current versions --=20
mostly workarounds that are no longer necessary.

Also, I found the first 4 chapters of O'reilly's book on PL/SQL programming=
 to=20
be invaluable in helping me develop an organized approach toward manageing =
a=20
database using functions.  However, the rest of the book is Oracle stuff no=
t=20
supported by Postgres, so you decide if it's worth the $50.

--=20
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh@agliodbs.com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 621-2533
    and non-profit organizations. 	San Francisco