SPI_execp
SPI_execp — execute a statement in read/write mode
Synopsis
int SPI_execp(SPIPlanPtrplan
, Datum *values
, const char *nulls
, longcount
)
Description
SPI_execp
is the same as SPI_execute_plan
, with the latter's read_only
parameter 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
isNULL
thenSPI_execp
assumes that no parameters are null. Otherwise, each entry of thenulls
array should be' '
if the corresponding parameter value is non-null, or'n'
if the corresponding parameter value is null. (In the latter case, the actual value in the correspondingvalues
entry doesn't matter.) Note thatnulls
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.