Thread: Question

Question

From
Brandon E Hofmann
Date:
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


Re: Question

From
"Uwe C. Schroeder"
Date:
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

Re: Question

From
Brandon E Hofmann
Date:
The procedure syntax CREATE PROCEDURE doesn't exist in 8.1.  What specific
topic are you referring to in your doc link reference?


Re: Question

From
Jaime Casanova
Date:
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 ;)