Re: [GENERAL] nested SQL with SPI

2001-09-04 Thread Tom Lane
Markus Wagner <[EMAIL PROTECTED]> writes: > this would mean that all result tables are kept in memory until the trigger > function exits? Until you do SPI_freetuptable or SPI_finish, yes, an SPI result sticks around. > What do you mean with "copy it and associated globals into locals", just the

Re: [GENERAL] nested SQL with SPI

2001-09-03 Thread Markus Wagner
Hi Tom, this would mean that all result tables are kept in memory until the trigger function exits? What do you mean with "copy it and associated globals into locals", just the pointers or the data itself? If I understand it the right way, I could something like in the code below, e. g. loop