Обсуждение: Question
Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE syntax. I notice pgAdmin III has a procedure section in addition to functions. I thought PostgreSQL implemented Stored Procedures before MySQL 5.0. I have a Sybase implementation with Stored Procedures that I want to convert to PostgreSQL. Do you have an example you can send me that shows a Stored Procedure returning a result set that can be displayed by Java? Any help you could provide would be greatly appreciated. Thanks, Brandon
How about reading the docs? http://www.postgresql.org/docs/8.1/interactive/server-programming.html is the chapter about stored procs On Tuesday 29 November 2005 09:12, Brandon E Hofmann wrote: > Does PostgreSQL include Stored Procedures supporting the CREATE PROCEDURE > syntax. I notice pgAdmin III has a procedure section in addition to > functions. I thought PostgreSQL implemented Stored Procedures before MySQL > 5.0. > > I have a Sybase implementation with Stored Procedures that I want to > convert to PostgreSQL. Do you have an example you can send me that shows a > Stored Procedure returning a result set that can be displayed by Java? > > Any help you could provide would be greatly appreciated. > > Thanks, > > Brandon > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- UC -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax: +1 707 568 6416
The procedure syntax CREATE PROCEDURE doesn't exist in 8.1. What specific topic are you referring to in your doc link reference?
On 11/30/05, Brandon E Hofmann <Brandon_E_Hofmann@notes.ntrs.com> wrote: > The procedure syntax CREATE PROCEDURE doesn't exist in 8.1. What specific > topic are you referring to in your doc link reference? > > even while we haven't CREATE PROCEDURE yet we can define a function and return VOID you can find some examples here: http://www.postgresql.org/docs/8.1/interactive/plpgsql-porting.html#PLPGSQL-PORTING-EX3 -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)