| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Agarwal | 2007-03-30 05:32:01 | Re: Data Encryption |
| Previous Message | Ramon Orticio | 2007-03-30 01:34:29 | PL/pgSQL how to install |