Index of /postgresql/postgres/spi-spi-execute-plan.html |
PostgreSQL 8.2.5 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Fast Forward | Next |
int SPI_execute_plan(void * plan, Datum * values, const char * nulls, bool read_only, long count)
SPI_execute_plan
executes a plan prepared by
SPI_prepare
. read_only and
count have the same interpretation as in
SPI_execute
.
execution plan (returned by SPI_prepare
)
An array of actual parameter values. Must have same length as the plan's number of arguments.
An array describing which parameters are null. Must have same length as the plan's number of arguments. 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_execute_plan
assumes that no parameters are
null.
true for read-only execution
maximum number of rows to process or return
The return value is the same as for SPI_execute
,
with the following additional possible error (negative) results:
if plan is NULL or count is less than 0
if values is NULL and plan was prepared with some parameters
SPI_processed and
SPI_tuptable are set as in
SPI_execute
if successful.
If one of the objects (a table, function, etc.) referenced by the
prepared plan is dropped during the session then the result of
SPI_execute_plan
for this plan will be unpredictable.
HIVE: All information for read only. Please respect copyright! |