Thread: PLSQL

PLSQL

From
"Sidar Lopez Cruz"
Date:
Can PostgreSQL functions return recordsets like stored procedures in oracle?

:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.

Re: PLSQL

From
Robert Treat
Date:
In version 7.3 they can do so. There is a tutorial available at
http://techdocs.postgresql.org/guides/SetReturningFunctions

Robert Treat

On Tue, 2003-02-25 at 10:33, Sidar Lopez Cruz wrote:
> Can PostgreSQL functions return recordsets like stored procedures in
> oracle?
>
> :-) Sidar Lopez Cruz
> - Cero Riesgo, S.A.




Re: PLSQL

From
Rajesh Kumar Mallah
Date:
Hmmm Looks like this has become a FAQ :-)

reds
mallah.

On Tuesday 25 February 2003 09:24 pm, Robert Treat wrote:
> In version 7.3 they can do so. There is a tutorial available at
> http://techdocs.postgresql.org/guides/SetReturningFunctions
>
> Robert Treat
>
> On Tue, 2003-02-25 at 10:33, Sidar Lopez Cruz wrote:
> > Can PostgreSQL functions return recordsets like stored procedures in
> > oracle?
> >
> > :-) Sidar Lopez Cruz
> >
> > - Cero Riesgo, S.A.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

Re: PLSQL

From
Robert Treat
Date:
You mean like http://www.postgresql.org/docs/faqs/FAQ.html#4.25 ?

Robert Treat

On Wed, 2003-02-26 at 02:13, Rajesh Kumar Mallah wrote:
>
> Hmmm Looks like this has become a FAQ :-)
>
> reds
> mallah.
>
> On Tuesday 25 February 2003 09:24 pm, Robert Treat wrote:
> > In version 7.3 they can do so. There is a tutorial available at
> > http://techdocs.postgresql.org/guides/SetReturningFunctions
> >
> > Robert Treat
> >
> > On Tue, 2003-02-25 at 10:33, Sidar Lopez Cruz wrote:
> > > Can PostgreSQL functions return recordsets like stored procedures in
> > > oracle?
> > >
> > > :-) Sidar Lopez Cruz
> > >
> > > - Cero Riesgo, S.A.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> --
>
> Regds
> Mallah
>
> ----------------------------------------
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



Re: PLSQL

From
Rajesh Kumar Mallah
Date:

Hmm i did'nt know its already there.

in anycase it does not tells abt the simplification
that has been introduced in 7.3.x regarding SRFs.

regds
mallah.

4.25) How do I return multiple rows or columns from a function?



You can return result sets from PL/pgSQL functions using refcursors. See
http://www.PostgreSQL.org/idocs/index.php?plpgsql-cursors.html, section
23.7.3.3.



On Wednesday 26 February 2003 10:34 pm, Robert Treat wrote:
> You mean like http://www.postgresql.org/docs/faqs/FAQ.html#4.25 ?
>
> Robert Treat
>
> On Wed, 2003-02-26 at 02:13, Rajesh Kumar Mallah wrote:
> > Hmmm Looks like this has become a FAQ :-)
> >
> > reds
> > mallah.
> >
> > On Tuesday 25 February 2003 09:24 pm, Robert Treat wrote:
> > > In version 7.3 they can do so. There is a tutorial available at
> > > http://techdocs.postgresql.org/guides/SetReturningFunctions
> > >
> > > Robert Treat
> > >
> > > On Tue, 2003-02-25 at 10:33, Sidar Lopez Cruz wrote:
> > > > Can PostgreSQL functions return recordsets like stored procedures in
> > > > oracle?
> > > >
> > > > :-) Sidar Lopez Cruz
> > > >
> > > > - Cero Riesgo, S.A.
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> > > commands go to majordomo@postgresql.org
> >
> > --
> >
> > Regds
> > Mallah
> >
> > ----------------------------------------
> > Rajesh Kumar Mallah,
> > Project Manager (Development)
> > Infocom Network Limited, New Delhi
> > phone: +91(11)6152172 (221) (L) ,9811255597 (M)
> >
> > Visit http://www.trade-india.com ,
> > India's Leading B2B eMarketplace.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

Re: PLSQL

From
Bruce Momjian
Date:
I have updated the FAQ with the set-returning functions URL.

Thanks.

---------------------------------------------------------------------------

Rajesh Kumar Mallah wrote:
>
>
> Hmm i did'nt know its already there.
>
> in anycase it does not tells abt the simplification
> that has been introduced in 7.3.x regarding SRFs.
>
> regds
> mallah.
>
> 4.25) How do I return multiple rows or columns from a function?
>
>
>
> You can return result sets from PL/pgSQL functions using refcursors. See
> http://www.PostgreSQL.org/idocs/index.php?plpgsql-cursors.html, section
> 23.7.3.3.
>
>
>
> On Wednesday 26 February 2003 10:34 pm, Robert Treat wrote:
> > You mean like http://www.postgresql.org/docs/faqs/FAQ.html#4.25 ?
> >
> > Robert Treat
> >
> > On Wed, 2003-02-26 at 02:13, Rajesh Kumar Mallah wrote:
> > > Hmmm Looks like this has become a FAQ :-)
> > >
> > > reds
> > > mallah.
> > >
> > > On Tuesday 25 February 2003 09:24 pm, Robert Treat wrote:
> > > > In version 7.3 they can do so. There is a tutorial available at
> > > > http://techdocs.postgresql.org/guides/SetReturningFunctions
> > > >
> > > > Robert Treat
> > > >
> > > > On Tue, 2003-02-25 at 10:33, Sidar Lopez Cruz wrote:
> > > > > Can PostgreSQL functions return recordsets like stored procedures in
> > > > > oracle?
> > > > >
> > > > > :-) Sidar Lopez Cruz
> > > > >
> > > > > - Cero Riesgo, S.A.
> > > >
> > > > ---------------------------(end of
> > > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> > > > commands go to majordomo@postgresql.org
> > >
> > > --
> > >
> > > Regds
> > > Mallah
> > >
> > > ----------------------------------------
> > > Rajesh Kumar Mallah,
> > > Project Manager (Development)
> > > Infocom Network Limited, New Delhi
> > > phone: +91(11)6152172 (221) (L) ,9811255597 (M)
> > >
> > > Visit http://www.trade-india.com ,
> > > India's Leading B2B eMarketplace.
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> --
>
> Regds
> Mallah
>
> ----------------------------------------
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073