From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: josh@agliodbs.com, Sandy Ear <sear@la-rubber.com>
To: pgsql-sql@postgresql.org
Subject: Re: PLPGSQL language documentation
Date: Tue, 9 Jul 2002 12:02:08 -0700 (PDT)
Message-ID: <20020709190208.55217.qmail@web20807.mail.yahoo.com> (raw)
In-Reply-To: <200207091011.36349.josh@agliodbs.com>
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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jeff_eckermann@yahoo.com, sear@la-rubber.com
Subject: Re: PLPGSQL language documentation
In-Reply-To: <20020709190208.55217.qmail@web20807.mail.yahoo.com>
* 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