Skip site navigation (1) Skip section navigation (2)

Re: Do Stored Procedures exist (Besides FUNCTIONs)

From: Clinton Adams <clinton(at)vote-smart(dot)org>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Do Stored Procedures exist (Besides FUNCTIONs)
Date: 2002-03-05 00:53:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
At 12:11 PM 3/4/2002 -0800, Josh Berkus wrote:
> > 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?


>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)

In response to

pgsql-novice by date

Next:From: Damon FaschingDate: 2002-03-05 03:13:38
Subject: executemany with select
Previous:From: Josh BerkusDate: 2002-03-05 00:30:34
Subject: Re: index item size 4496 exceeds maximum 2713

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group