Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
SPI_execp
Prev Up45.1. Interface FunctionsHome Next

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 asSPI_execute_plan, with the latter'sread_only parameter always taken asfalse.

Arguments

SPIPlanPtrplan

prepared statement (returned bySPI_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.

Ifnulls 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.

longcount

maximum number of rows to return, or0 for no limit

Return Value

SeeSPI_execute_plan.

SPI_processed andSPI_tuptable are set as inSPI_execute if successful.


Prev Up Next
SPI_execute_plan_with_paramlist Home SPI_cursor_open
pdfepub
Go to PostgreSQL 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp