SPI_EXECUTE_PLAN(3) PostgreSQL 9.2.7 Documentation SPI_EXECUTE_PLAN(3)NAME
SPI_execute_plan - execute a statement prepared by SPI_prepare
SYNOPSIS
int SPI_execute_plan(SPIPlanPtr plan, Datum * values, const char * nulls,
bool read_only, long count)
DESCRIPTION
SPI_execute_plan executes a statement prepared by SPI_prepare or one of its siblings. read_only and count have the same interpretation as
in SPI_execute.
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. 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.
bool read_only
true for read-only execution
long count
maximum number of rows to return, or 0 for no limit
RETURN VALUE
The return value is the same as for SPI_execute, with the following additional possible error (negative) results:
SPI_ERROR_ARGUMENT
if plan is NULL or invalid, or count is less than 0
SPI_ERROR_PARAM
if values is NULL and plan was prepared with some parameters
SPI_processed and SPI_tuptable are set as in SPI_execute if successful.
PostgreSQL 9.2.7 2014-02-17 SPI_EXECUTE_PLAN(3)
Check Out this Related Man Page
SPI_CURSOR_OPEN_WITH_PARAMLIST(3) PostgreSQL 9.2.7 Documentation SPI_CURSOR_OPEN_WITH_PARAMLIST(3)NAME
SPI_cursor_open_with_paramlist - set up a cursor using parameters
SYNOPSIS
Portal SPI_cursor_open_with_paramlist(const char *name,
SPIPlanPtr plan,
ParamListInfo params,
bool read_only)
DESCRIPTION
SPI_cursor_open_with_paramlist sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. This function
is equivalent to SPI_cursor_open except that information about the parameter values to be passed to the query is presented differently. The
ParamListInfo representation can be convenient for passing down values that are already available in that format. It also supports use of
dynamic parameter sets via hook functions specified in ParamListInfo.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
ARGUMENTS
const char * name
name for portal, or NULL to let the system select a name
SPIPlanPtr plan
prepared statement (returned by SPI_prepare)
ParamListInfo params
data structure containing parameter types and values; NULL if none
bool read_only
true for read-only execution
RETURN VALUE
Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.
PostgreSQL 9.2.7 2014-02-17 SPI_CURSOR_OPEN_WITH_PARAMLIST(3)
I am new to shell, and I am trying to do a if statement like the following:
if ; then
basically it works fine if both arguments of the if are met, however the next elif is:
elif ; then
if the conditions of the elif are met, then it says "final1.sh: line 67: [: too many arguments"
... (6 Replies)
Hello all,
I am trying to create a script that can read a file and produce a count per date (such as a case statement of some kind):
This is a sample of the data:
05-01 02
05-01 02
05-01 02
05-01 02
05-01 02
05-01 02
05-01 02
05-01 03
05-01 03
05-01 03
05-01 03
05-01 03
05-01... (13 Replies)
Hello. My first post.
I have values stored in my .zshrc file. These are unimportant but often required. The plan is to write a function (get()) to access the values and copy to the pasteboard as required.
e.g.- EML='thisistricky2@yahoo.com.au' (this in .zshrc)
want the function call get EML to... (5 Replies)
Hi Admins,
I was told to add new ip,mask and gateway to my 3rd nic.so i prepared a plan doing the same via smitty. now i need to know do i plumb and unplumb before adding ip.
plz suggest
Regards
newaix (1 Reply)
I'm stuck on a particular problem and need some guidance. I have a file with a name and a phone number in it (teledir.txt). I need to do a $# in a separate script to take a positional parameter and check to see if it is in the file. To quote the question:
If one argument is supplied, check... (6 Replies)