Re: Use of cursor in PLPGSQL function

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Use of cursor in PLPGSQL function
Дата
Msg-id 200112052048.fB5Kmur01873@saturn.jw.home
обсуждение исходный текст
Ответ на Use of cursor in PLPGSQL function  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Sparc v Intel
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Exited with status. . . codes