Re: PLPGSQL language documentation

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