PostgreSQL

PostgreSQL Elephant Logo

SPI_execp

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 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 `nulls 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 corresponding `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.


Prev Up Next

SPI_execute_plan_with_paramlist

Home

SPI_cursor_open

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