Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SPI_KEEPPLAN(3)		PostgreSQL 9.6.19 Documentation	       SPI_KEEPPLAN(3)

NAME
       SPI_keepplan - save a prepared statement

SYNOPSIS
       int SPI_keepplan(SPIPlanPtr plan)

DESCRIPTION
       SPI_keepplan saves a passed statement (prepared by SPI_prepare) so that
       it will not be freed by SPI_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
       SPIPlanPtr plan
	   the prepared	statement to be	saved

RETURN VALUE
       0 on success; SPI_ERROR_ARGUMENT	if plan	is NULL	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, use SPI_freeplan on it.

PostgreSQL 9.6.19		     2020		       SPI_KEEPPLAN(3)

NAME | SYNOPSIS | DESCRIPTION | ARGUMENTS | RETURN VALUE | NOTES

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SPI_keepplan&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help