Re: Use of cursor in PLPGSQL function

Mourad EL HADJ MIMOUNE wrote:
> Hi,
> I want to use cursors in PLPGSQL functions but without success.
> I downloaded a file gram.y to update PLPGSQL parser.
> I would know how can I make this update, and if this will allows me to use
> cursors in plpgsql functions.
> Thanks for your help.
> Mourad.

There is no way to use cursors inside of PL/pgSQL functions
before Postgres version 7.2. It's not just the syntax parsed
by the function handler. There have been enhancements in the
server, namely cursor support in SPI, that make it possible
at all.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com