re-post

Amy Cheng requested that I post her reply to me back to the list since she did
not have a copy of it.
  -M@

hi,

search or browse "functions" and "PL/pgSQL" (and tcl and c/spi), "triggers".
enough to start-up ;-)
also, there is examples in the source's test directory.

but, you are right, not in depth enough. I asked Several times, in
different forms, in this list, NOT a SINGLE answer! Seems that
nice expert are scarce nowadays. Let me put those questions
together anyway, let's see ...

the difference between Oralce's PL/SQL and PL/pgSQL (so
that we can use the books on PL/SQL),

the difference between PL/pgSQL and tcl (note that postgreSQL also support
tcl now),

does PL/pgSQL support array-like feature? how about tcl in postgreSQL?

if I want use OS (i.e. external to dababase), can I use PL/pgSQL or tcl? if
in C (spi), is it easy? anyway to get perl involved?


>From: Matthew Hixson <hixson@frozenwave.com>
>Reply-To: hixson@frozenwave.com
>To: pgsql-general@postgresql.org
>Subject: [GENERAL] stored procedures
>Date: Mon, 30 Aug 1999 12:58:45 -0700
>
>Could someone point me to a tutorial or HOWTO regarding stored procedures?
>I
>know very little about them and need to learn everything I possibly can
>about
>them as soon as possible.  I looked throught the Postgres docs and couldn't
>find anything that goes into them in depth.
>      Thank you,
>      -M@




--
Matthew Hixson - CIO
FroZenWave Communications
http://www.frozenwave.com