Thread: PL/pgSQL how to install

dear friends,

may i ask how to install PL/pgSQL. what is the
difference between PL/pgSQL and postgreSQL. Is the
former already included in the latter when it is
installed. If no where can i get files for
installation of PL/pgSQL.

thank you for your concern.

raport






____________________________________________________________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail

> may i ask how to install PL/pgSQL. what is the
> difference between PL/pgSQL and postgreSQL. Is the
> former already included in the latter when it is
> installed. If no where can i get files for
> installation of PL/pgSQL.

Take a look at Procedural Languages and CREATE language in the postgresql Manual:
http://www.postgresql.org/docs/8.2/interactive/plpgsql.html
http://www.postgresql.org/docs/8.2/interactive/sql-createlanguage.html#SQL-CREATELANGUAGE-EXAMPLE

basically, PL/pgSQL is one of the many procedural languages that you can use to create value, set,
and trigger returning functions.

IIRC, trigger functions can only be created with procedural languages. However, the other
functions can be using standard SQL.

I hope this helps.

Regards,
Richard Broersma Jr.

dear friends,

thank you so much for your help.

---

Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.