From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Sean <scene(at)themountainscene(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Sstored Procedures |
Date: | 2005-06-29 13:03:42 |
Message-ID: | 20050629130342.GA31343@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Jun 28, 2005 at 02:20:35PM -0600, Sean wrote:
> Are there any good resources on stored procedures? I'm not very
> familiar with them, so if with regards to php is important, then
> resources with regards to php it is then. Thanks.
See "Server Programming" in the documentation. The chapter on
PL/pgSQL will probably be the most useful:
http://www.postgresql.org/docs/8.0/static/server-programming.html
http://www.postgresql.org/docs/8.0/static/plpgsql.html
(The above links are to the 8.0 documentation; use the documentation
for whatever version of PostgreSQL you're running.)
See also examples at sites like General Bits:
http://www.varlena.com/varlena/GeneralBits/
You could also use a search engine to search for phrases like "CREATE
FUNCTION" and "plpgsql". If you have specific questions about how
to do something, then ask on the PostgreSQL mailing lists.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Walker, Jed S | 2005-06-29 14:57:32 | Does a user have usage on a schema? |
Previous Message | Vincenzo Romano | 2005-06-29 11:30:07 | Rule creation and evaluation order |