Re: nested SQL with SPI

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: nested SQL with SPI
Дата
Msg-id 200109041732.f84HWmd01781@jupiter.us.greatbridge.com
обсуждение исходный текст
Ответ на nested SQL with SPI  (Markus Wagner <wagner@imsd.uni-mainz.de>)
Список pgsql-general
Markus Wagner wrote:
[Charset iso-8859-15 unsupported, filtering to ASCII...]
> Hi,
>
> can I nest SQL statements with SPI within trigger functions?
> How can I distinguish the results in SPI_tuptable?

    You  can. Look at how PL/pgSQL deals with result sets used in
    FOR loops. Probably you want to look at 7.1 code, because the
    7.2 code uses SPI cursor support for that already.


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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: FOREIGN KEY: difference between NOT DEFERRABLE and
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg7.1 release date