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 C function 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.