Re: Do Stored Procedures exist (Besides FUNCTIONs)

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Art Nicewick" <art(dot)nicewick(at)ams(dot)com>, Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Do Stored Procedures exist (Besides FUNCTIONs)
Date: 2002-03-04 20:11:33
Message-ID: web-816381@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Art Nicewick 2002-03-04 20:44:58 Re: Do Stored Procedures exist (Besides FUNCTIONs)
Previous Message ebp 2002-03-04 19:13:23 Primary Key problem