: How to create stored procedure in PostgreSQL?

Yolanda Valverde wrote:

Hello

I don't see to create stored procedure in postgresql. Do you
tell me how to do it? or which document do I have to read?

Hi Yolanda,

You'd be looking for the "Procedural Languages" part of the PostgreSQL
documentation:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=programmer-pl.html

Also, this article by Stephan Szabo should help too:

http://techdocs.postgresql.org/guides/SetReturningFunctions
Shows how to return more than one row of data from PL/pgSQL functions

:-)

Regards and best wishes,

Justin Clift

Thanks.

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

On Mon, 3 Feb 2003, Yolanda Valverde wrote:

Hello

I don't see to create stored procedure in postgresql. Do you
tell me how to do it? or which document do I have to read?

http://developer.postgresql.org/docs/postgres/programmer-pl.html
http://developer.postgresql.org/docs/postgres/sql-createfunction.html

both from the Refernce Manual:

http://developer.postgresql.org/docs/postgres/reference.html

Which is itself within:

http://developer.postgresql.org/docs/postgres/

--
Nigel J. Andrews