Re: nested SQL with SPI

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