Обсуждение: : How to create stored procedure in PostgreSQL?
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? Thanks.
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