Received: from web20807.mail.yahoo.com (web20807.mail.yahoo.com
	[216.136.226.196])
	by postgresql.org (Postfix) with SMTP id D5DFE47591D
	for <pgsql-sql@postgresql.org>; Tue,  9 Jul 2002 15:02:08 -0400 (EDT)
Message-ID: <20020709190208.55217.qmail@web20807.mail.yahoo.com>
Received: from [208.13.35.65] by web20807.mail.yahoo.com via HTTP;
	Tue, 09 Jul 2002 12:02:08 PDT
Date: Tue, 9 Jul 2002 12:02:08 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: PLPGSQL language documentation
To: josh@agliodbs.com, Sandy Ear <sear@la-rubber.com>,
 pgsql-sql@postgresql.org
In-Reply-To: <200207091011.36349.josh@agliodbs.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200207/121
X-Sequence-Number: 8500

I'll second the suggestion about looking at Oracle
PL/SQL materials.  I used an introductory PL/SQL text
when learning about PLpgSQL, and found it very useful.
The syntax/functionality is highly similar (by design,
apparently).  Much of the Oracle PL/SQL functionality
is not (yet) implemented in PLpgSQL however, so better
to avoid detailed Oracle texts.  Skip over the stuff
about explicit cursors and exception handlers.

--- Josh Berkus <josh@agliodbs.com> wrote:
> 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 
> Languages"
> 
> 2. Roberto' Mello's enhanced documentation,
> accessable through 
> techdocs.postgresql.org.  Roberto also has a PLpgSQL
> function library that 
> should give you some good examples.  However, this
> is entirely for Postgres 
> 7.0 and 7.1, so there are some syntax changes in the
> current versions -- 
> mostly workarounds that are no longer necessary.
> 
> Also, I found the first 4 chapters of O'reilly's
> book on PL/SQL programming to 
> be invaluable in helping me develop an organized
> approach toward manageing a 
> database using functions.  However, the rest of the
> book is Oracle stuff not 
> supported by Postgres, so you decide if it's worth
> the $50.
> 
> -- 
> -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
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com