SPI_cursor_open — set up a cursor using a statement created
Portal SPI_cursor_open(const char *
plan, Datum *
values, const char *
SPI_cursor_open sets up a
cursor (internally, a portal) that will execute a statement
parameters have the same meanings as the corresponding
Using a cursor instead of executing the statement directly has two benefits. First, the result rows can be retrieved a few at a time, avoiding memory overrun for queries that return many rows. Second, a portal can outlive the current C function (it can, in fact, live to the end of the current transaction). Returning the portal name to the C function's caller provides a way of returning a row set as result.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
const char *
name for portal, or
to let the system select a name
prepared statement (returned by
An array of actual parameter values. Must have same length as the statement's number of arguments.
const char *
An array describing which parameters are null. Must have same length as the statement's number of arguments.
SPI_cursor_open assumes that no
parameters are null. Otherwise, each entry of the
' ' 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
true for read-only
Pointer to portal containing the cursor. Note there is no
error return convention; any error will be reported via
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.