Thread: re-post

re-post

From
Matthew Hixson
Date:
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

Re: [GENERAL] re-post

From
Teodor Cimpoesu
Date:
Matthew Hixson wrote:
>
> 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.
I can answer least 50% on all of your question only after reading the
"programmer's guide",
one night,( and was also doin' a Postgres+Apache+PHP installation in
parallel).
So did you rtfm?
If yes let me share:


> 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),
afaik, PL/pgSQL is pretty like PL/SQL except it cannot use cursors,
and arrays I think.

> the difference between PL/pgSQL and tcl (note that postgreSQL also support
> tcl now),
eww, a big one. tcl is rather a programming language, PL/pgSQL, as it's
name states
is a procedural language, used only in functions.

> does PL/pgSQL support array-like feature? how about tcl in postgreSQL?
dunno, did you try?

> 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?
?? I didn't get this Q, if you are refering to postgres API, if you can
use PL/pgSQL
in, say, C code, I think everything that backend sais is valid, will be.
Also have a look @ ecpg. The cleaner way is through libpq. And the C++
API looks also nice.
And yep , you can get perl involved through it's DBI.

--
CIMPOESU Teodor, Web Programmer

@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ teo@digiro.net,+(401)-330.47.28

official home page ~ http://www.digiro.net/
Internet  web page ~ http://internet.digiro.net/