SPI_keepplan
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
SPIPlanPtrplanthe 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.