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

From Clinton Adams
Subject Re: Do Stored Procedures exist (Besides FUNCTIONs)
Date
Msg-id 5.0.2.1.0.20020304173749.02517590@mail.vote-smart.org
Whole thread Raw
In response to Re: Do Stored Procedures exist (Besides FUNCTIONs)  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
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@postgresql.org)



pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: index item size 4496 exceeds maximum 2713
Next
From: Damon Fasching
Date:
Subject: executemany with select