Thread: PLSQL
Can PostgreSQL functions return recordsets like stored procedures in oracle?
:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.
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.
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.
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)
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.
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