Re: PL/pgSQL how to install

> 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.