| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: nested SQL with SPI |
| Date: | 2001-09-04 17:32:48 |
| Message-ID: | 200109041732.f84HWmd01781@jupiter.us.greatbridge.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jefim Matskin | 2001-09-04 17:36:51 | Index usage question |
| Previous Message | E Kolve | 2001-09-04 17:22:19 | Re: many junction tables |