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.htmlhttp://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/