pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPLPGSQL language documentation
4+ messages / 4 participants
[nested] [flat]
* PLPGSQL language documentation
@ 2002-07-08 22:45 Sandy Ear <sear@la-rubber.com>
2002-07-09 17:10 ` Re: PLPGSQL language documentation Bradley Kieser <brad@kieser.net>
2002-07-09 17:11 ` Re: PLPGSQL language documentation Josh Berkus <josh@agliodbs.com>
0 siblings, 2 replies; 4+ messages in thread
From: Sandy Ear @ 2002-07-08 22:45 UTC (permalink / raw)
To: pgsql-sql
I was wondering if anyone knew of good online documentation on PlPgsql?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PLPGSQL language documentation
2002-07-08 22:45 PLPGSQL language documentation Sandy Ear <sear@la-rubber.com>
@ 2002-07-09 17:10 ` Bradley Kieser <brad@kieser.net>
1 sibling, 0 replies; 4+ messages in thread
From: Bradley Kieser @ 2002-07-09 17:10 UTC (permalink / raw)
To: Sandy Ear <sear@la-rubber.com>; +Cc: pgsql-sql
Hear hear!
We have been looking for it as well!
We have avoided using triggers to date because we do not know how to
program in the language!
Sandy Ear wrote:
> I was wondering if anyone knew of good online documentation on PlPgsql?
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PLPGSQL language documentation
2002-07-08 22:45 PLPGSQL language documentation Sandy Ear <sear@la-rubber.com>
@ 2002-07-09 17:11 ` Josh Berkus <josh@agliodbs.com>
2002-07-09 19:02 ` Re: PLPGSQL language documentation Jeff Eckermann <jeff_eckermann@yahoo.com>
1 sibling, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2002-07-09 17:11 UTC (permalink / raw)
To: Sandy Ear <sear@la-rubber.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PLPGSQL language documentation
2002-07-08 22:45 PLPGSQL language documentation Sandy Ear <sear@la-rubber.com>
2002-07-09 17:11 ` Re: PLPGSQL language documentation Josh Berkus <josh@agliodbs.com>
@ 2002-07-09 19:02 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jeff Eckermann @ 2002-07-09 19:02 UTC (permalink / raw)
To: josh@agliodbs.com, Sandy Ear <sear@la-rubber.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-07-09 19:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-08 22:45 PLPGSQL language documentation Sandy Ear <sear@la-rubber.com>
2002-07-09 17:10 ` Bradley Kieser <brad@kieser.net>
2002-07-09 17:11 ` Josh Berkus <josh@agliodbs.com>
2002-07-09 19:02 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
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