Postgresql 中文操作指南

SPI_execp

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 与 SPI_execute_plan 相同，后者的 read_only 参数始终被视为 false 。

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

参见 SPI_execute_plan 。

See SPI_execute_plan.

如果成功，则 SPI_processed 和 SPI_tuptable 与 SPI_execute 中的设置相同。

SPI_processed and SPI_tuptable are set as in SPI_execute if successful.