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
