Re: Do Stored Procedures exist (Besides FUNCTIONs)

At 12:11 PM 3/4/2002 -0800, Josh Berkus wrote:
>Art,
>
> > It seems the all the discussions in the ORACLE TO PGSQL port document
> > are
> > all about converting FUNCTIONs to FUNCTIONs, Procedures to FUNCTIONs.
> > What
> > about application that already return multiple parameters from a
> > stored
> > procedure.
>
>This is an area currently under development for PostgreSQL. There is
> some limited ability to return recordsets from Postgres using cursor
> and/or Record objects. However, I do not know that this is yet
> documented, as the functionality was just added for 7.2.

Cursor and record objects, eh? What is the return type for those?

/clinton

>Overall, stored procedures like you describe remain on the "To Do"
> list.
>
>-Josh Brkus
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)