Thread: PL/pgSQL manual?

Thanks for the input concerning the functions / triggers. Now I'm still
kinda lost... Is there a manual etc... For PL/pgSQL? I've been all over
the documentation for my release (7.2) and I can't find much in the way
of getting started.

Thanks,
    Paul

 ***PRIVILEGED & CONFIDENTIAL***
Unless expressly stated otherwise, this message (and any attachment(s)
thereto) is confidential and may be privileged. It is intended for the
addressee(s) only. If you are not an addressee, any disclosure or
copying of the contents of this e-mail or any action taken (or not
taken) in reliance on it is strictly prohibited. If you are not an
addressee, please inform sender immediately and delete this message from
your system.

> Thanks for the input concerning the functions / triggers. Now I'm still
> kinda lost... Is there a manual etc... For PL/pgSQL? I've been all over
> the documentation for my release (7.2) and I can't find much in the way
> of getting started.=20

Chapter 11 in the Worsley & Drake's "Practical PostgrSQL", from O'Reilly
is a good introduction to pl/pgsql though it doesn't get into trigger
programming in much detail.

The book is based on pgsql 7.1.3 and is thus missing information about
enhancements to pgsql since then.  The challenge to an author is to keep the
book as current as possible while also presenting historical differences for
users on older releases.  The challenge to the publisher is to keep from
being stuck with an inventory of out-of-date books.  :-)

Some of the Oracle PL/SQL books (see the O'Reilly website for examples)
may also be instructive, if one keeps in mind that despite being based
largely upon PL/SQL there appears to be some fundamental differences between
PL/SQL and pl/pgsql.  Pl/pgsql seems to make it easier to use the
pgsql backend to use SQL structure for manipulating variables, for example.
--
Mike Nolan