Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL how to install

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Ramon Orticio <rporticio(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: PL/pgSQL how to install
Date: 2007-03-30 05:29:44
Message-ID: 3552.76796.qm@web31806.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> 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. 

In response to

pgsql-novice by date

Next:From: Sandeep AgarwalDate: 2007-03-30 05:32:01
Subject: Re: Data Encryption
Previous:From: Ramon OrticioDate: 2007-03-30 01:34:29
Subject: PL/pgSQL how to install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group