Thread: Real newbie question re documentation for PL/SQL

Hi,

I keep seeing references to server side scripting and something called
PL/SQL, I found some mention of extending it in the programmers
reference, but I am unable to find any reference material, is there such
a thing, and if so, where can I find it.

Related topic, are the functions in pg_proc documented anywhere?

Thanks much.

--
Stand Fast,
    tjg.

Chief Technology Officer              tjg@exceptionalminds.com
Red Hat Certified Engineer            www.exceptionalminds.com
Avalon Technology Group, Inc.                   (503) 246-3630
>>>>>>>>>>>>Linux...Because rebooting isn't normal<<<<<<<<<<<<

Timothy Grant wrote:
>
> Hi,
>
> I keep seeing references to server side scripting and something called
> PL/SQL, I found some mention of extending it in the programmers
> reference, but I am unable to find any reference material, is there such
> a thing, and if so, where can I find it.

Here are a few pl/pgsql references I've found helpful:

Enabling PL/pgSQL:  http://www.deja.com/getdoc.xp?AN=548176178

The "manual", AFAIK:
http://www.postgresql.org/docs/postgres/xplang19388.html

Examples:  .../postgresql-6.5.*/src/test/regress/sql/plpgsql.sql

Cheers,
Ed Loehr

Ed Loehr wrote:
>
> Timothy Grant wrote:
> >
> > Hi,
> >
> > I keep seeing references to server side scripting and something called
> > PL/SQL, I found some mention of extending it in the programmers
> > reference, but I am unable to find any reference material, is there such
> > a thing, and if so, where can I find it.
>
> Here are a few pl/pgsql references I've found helpful:
>
> Enabling PL/pgSQL:  http://www.deja.com/getdoc.xp?AN=548176178
>
> The "manual", AFAIK:
> http://www.postgresql.org/docs/postgres/xplang19388.html

And for some reason still unknown to me, when I click on the link
above, I get a 404 error (not found).  I noticed the same in the deja
reference above.  I figured the pg folks had moved the doc, but not
so.  You can find it via the pg website via the following path:

"Info Central"->"Documentation"->"Documentation"->"Integrated
Document" in Section III.43 under "PL/pgSQL".

Cheers,
Ed Loehr

>
> Examples:  .../postgresql-6.5.*/src/test/regress/sql/plpgsql.sql
>
> Cheers,
> Ed Loehr