Question

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 ;)