> 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:
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.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Sandeep Agarwal||Date: 2007-03-30 05:32:01|
|Subject: Re: Data Encryption|
|Previous:||From: Ramon Orticio||Date: 2007-03-30 01:34:29|
|Subject: PL/pgSQL how to install|