spi_execp

SPI_execp()	       PostgreSQL 7.4.19 Documentation		  SPI_execp()



NAME
       SPI_execp - executes a plan prepared by SPI_prepare


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


DESCRIPTION
       SPI_execp executes a plan prepared by SPI_prepare. tcount has the same
       interpretation as in SPI_exec.

ARGUMENTS
       void * plan
	      execution plan (returned by SPI_prepare)

       Datum *values
	      actual parameter values

       const char * nulls
	      An array describing which parameters are null.  n	 indicates  a
	      null value (entry in values will be ignored); a space indicates
	      a nonnull value (entry in values is valid).

	      If nulls is NULL then SPI_execp assumes that no parameters  are
	      null.

       int count
	      number of row for which plan is to be executed

RETURN VALUE
       The return value is the same as for SPI_exec or one of the following:

       SPI_ERROR_ARGUMENT
	      if plan is NULL or count is less than 0

       SPI_ERROR_PARAM
	      if values is NULL and plan was prepared with some parameters


       SPI_processed and SPI_tuptable are set as in SPI_exec if successful.

NOTES
       If one of the objects (a table, function, etc.) referenced by the pre-
       pared plan is dropped during the session then the result of  SPI_execp
       for this plan will be unpredictable.



				  2008-01-03			  SPI_execp()