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

  
 
  

home | help
SPI_EXECP(3)		  PostgreSQL 18.6 Documentation 	    SPI_EXECP(3)

NAME
     SPI_execp - execute a statement in read/write mode

SYNOPSIS
     int SPI_execp(SPIPlanPtr plan, Datum * values, const char * nulls, long count)

DESCRIPTION
     SPI_execp	is the same as SPI_execute_plan, with the latter's read_only pa-
     rameter always taken as false.

ARGUMENTS
     SPIPlanPtr plan
	 prepared statement (returned by SPI_prepare)

     Datum * values
	 An array of actual parameter values.  Must  have  same  length  as  the
	 statement's number of arguments.

     const char * nulls
	 An array describing which parameters are null. Must have same length as
	 the statement's number of arguments.

	 If  nulls  is	NULL then SPI_execp assumes that no parameters are null.
	 Otherwise, each entry of the nulls array should be ' '  if  the  corre-
	 sponding parameter value is non-null, or 'n' if the corresponding para-
	 meter	value is null. (In the latter case, the actual value in the cor-
	 responding values entry doesn't matter.) Note that nulls is not a  text
	 string, just an array: it does not need a '\0' terminator.

     long count
	 maximum number of rows to return, or 0 for no limit

RETURN VALUE
     See SPI_execute_plan.

     SPI_processed and SPI_tuptable are set as in SPI_execute if successful.

PostgreSQL 18.6 		      2026			    SPI_EXECP(3)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=SPI_execp&sektion=3&manpath=FreeBSD+Ports+15.1.quarterly>

home | help