Search PostgreSQL documentation

ArgumentsManual ChaptersPG18Arguments Portal portal portal containing the cursor bool forward true for move forward, false for move backward long count maximum number of rows to moveArguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes an…Arguments ArgumentsManual ChaptersPG18Arguments 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 containi…Arguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name SPIPlanPtr plan prepared statement (returned by SPI_prepare) Datum * values An array of actual parameter …Arguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name const char * command command string const SPIParseOpenOptions * options struct containing optional argume…Arguments ArgumentsManual ChaptersPG18Arguments const char * command string containing command to execute long count maximum number of rows to return, or 0 for no limitArguments ArgumentsManual ChaptersPG18Arguments 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…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string const SPIExecuteOptions * options struct containing optional arguments Callers should always zero out the entire options struct, then fill which…Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) const SPIExecuteOptions * options struct containing optional arguments Callers should always zero out the entire option…Arguments ArgumentsManual ChaptersPG18Arguments 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-on…Arguments ArgumentsManual ChaptersPG18Arguments 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…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes an array of length nargs, containing the OIDs of the data types of the parame…Arguments ArgumentsManual ChaptersPG18Arguments const char * command string containing command to execute bool read_only true for read-only execution long count maximum number of rows to return, or 0 for no limitArguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description const char * colname column nameArguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan pointer to statement to freeArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row row to freeArguments ArgumentsManual ChaptersPG18Arguments SPITupleTable * tuptable pointer to row set to free, or NULL to do nothingArguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) int argIndex zero based index of the argumentArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row input row to be examined TupleDesc rowdesc input row description int colnumber column number (count starts at 1) bool * isnull flag for a null value in the columnArguments ArgumentsManual ChaptersPG18Arguments Relation rel input relationArguments ArgumentsManual ChaptersPG18Arguments Relation rel input relationArguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments HeapTuple row input row to be examined TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan the prepared statement to be savedArguments ArgumentsManual ChaptersPG18Arguments Relation rel Used only as the source of the row descriptor for the row. (Passing a relation rather than a row descriptor is a misfeature.) HeapTuple row row to be modified int ncol…Arguments ArgumentsManual ChaptersPG18Arguments Size size size in bytes of storage to allocateArguments ArgumentsManual ChaptersPG18Arguments void * pointer pointer to existing storage to freeArguments ArgumentsManual ChaptersPG18Arguments const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes pointer to an array containing the OIDs of the data types of the parameters i…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string const SPIPrepareOptions * options struct containing optional arguments Callers should always zero out the entire options struct, then fill which…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string ParserSetupHook parserSetup Parser hook setup function void * parserSetupArg pass-through argument for parserSetup int cursorOptions integer bit…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes pointer to an array containing the OIDs of the data types of the parametersArguments ArgumentsManual ChaptersPG18Arguments EphemeralNamedRelation enr the ephemeral named relation registry entryArguments ArgumentsManual ChaptersPG18Arguments TriggerData *tdata the TriggerData object passed to a trigger handler function as fcinfo->contextArguments ArgumentsManual ChaptersPG18Arguments int code result codeArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row row to be copied TupleDesc rowdesc descriptor for row (pass the same descriptor each time for most effective caching)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan the prepared statement to be savedArguments