Re: Do Stored Procedures exist (Besides FUNCTIONs) - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Do Stored Procedures exist (Besides FUNCTIONs)
Date
Msg-id web-816381@davinci.ethosmedia.com
Whole thread Raw
In response to Do Stored Procedures exist (Besides FUNCTIONs)  ("Art Nicewick" <art.nicewick@ams.com>)
Responses Re: Do Stored Procedures exist (Besides FUNCTIONs)
List pgsql-novice
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.

Overall, stored procedures like you describe remain on the "To Do"
 list.

-Josh Brkus


pgsql-novice by date:

Previous
From: pgsql@digitalmindgames.com
Date:
Subject: Re: phppgadmin
Next
From: "Josh Berkus"
Date:
Subject: Re: Do Stored Procedures exist (Besides FUNCTIONs)