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@Yahoo.com #



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