SPI_keepplan
Name
SPI_keepplan -- save a prepared statement
Synopsis
int SPI_keepplan(SPIPlanPtrplan)
Description
SPI_keepplan saves a passed statement (prepared bySPI_prepare) so that it will not be freed bySPI_finish nor by the transaction manager. This gives you the ability to reuse prepared statements in the subsequent invocations of your procedure in the current session.
Arguments
- SPIPlanPtrplan
the prepared statement to be saved
Return Value
0 on success;SPI_ERROR_ARGUMENT ifplan isNULL or invalid
Notes
The passed-in statement is relocated to permanent storage by means of pointer adjustment (no data copying is required). If you later wish to delete it, useSPI_freeplan on it.
