Re: Sstored Procedures

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/