Обсуждение: FETCH ... INTO in PL/pgSQL
Tom, Bruce, Is there any way to make use of the contents of a cursor in a PL/pgSQL function? FETCH ... INTO isn't supported, according to the docs. Can I use the dot notation, or something similar? -Josh -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
Josh Berkus wrote: > Tom, Bruce, > > Is there any way to make use of the contents of a cursor in a PL/pgSQL > function? FETCH ... INTO isn't supported, according to the docs. Can I > use the dot notation, or something similar? PL/pgSQL doesn't support cursors at all. That's basically a fault of the SPI manager because every internal DB access from withing PL/pgSQL is done via SPI and that beast doesn't support cursors. As said, I want to work on thatfor 7.2. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com