PostgreSQL
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
is `NULL then
SPI_execp
assumes that no parameters are null. Otherwise, each entry of the `nullsarray 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 corresponding `valuesentry 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
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group