Re: nested SQL with SPI - Mailing list pgsql-general

From Jan Wieck
Subject Re: nested SQL with SPI
Date
Msg-id 200109041732.f84HWmd01781@jupiter.us.greatbridge.com
Whole thread Raw
In response to nested SQL with SPI  (Markus Wagner <wagner@imsd.uni-mainz.de>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: FOREIGN KEY: difference between NOT DEFERRABLE and
Next
From: Bruce Momjian
Date:
Subject: Re: pg7.1 release date