Re: Use of cursor in PLPGSQL function - Mailing list pgsql-general

From Jan Wieck
Subject Re: Use of cursor in PLPGSQL function
Date
Msg-id 200112052048.fB5Kmur01873@saturn.jw.home
Whole thread Raw
In response to Use of cursor in PLPGSQL function  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Sparc v Intel
Next
From: Andrew Sullivan
Date:
Subject: Exited with status. . . codes