sposv.f – Synopsis Functions/Subroutines subroutine sposv (UPLO, N, NRHS, A, LDA, B, LDB, INFO) SPOSV computes the solution to system of linear equations A * X = B for PO matrices Function/Subroutine Documentation subroutine sposv (characterUPLO, integerN, integerNRHS, real, dimension( lda, * )A, integerLDA, real, dimension( ldb, * )B, integerLDB, integerINFO) SPOSV computes the solution…
NAME sporfsx.f – SYNOPSIS Functions/Subroutines subroutine sporfsx (UPLO, EQUED, N, NRHS, A, LDA, AF, LDAF, S, B, LDB, X, LDX, RCOND, BERR, N_ERR_BNDS, ERR_BNDS_NORM, ERR_BNDS_COMP, NPARAMS, PARAMS, WORK, IWORK, INFO) SPORFSX Function/Subroutine Documentation subroutine sporfsx (characterUPLO, characterEQUED, integerN, integerNRHS, real, dimension( lda, * )A, integerLDA, real, dimension( ldaf, * )AF, integerLDAF, real, dimension( * )S,…
NAME sporfs.f – SYNOPSIS Functions/Subroutines subroutine sporfs (UPLO, N, NRHS, A, LDA, AF, LDAF, B, LDB, X, LDX, FERR, BERR, WORK, IWORK, INFO) SPORFS Function/Subroutine Documentation subroutine sporfs (characterUPLO, integerN, integerNRHS, real, dimension( lda, * )A, integerLDA, real, dimension( ldaf, * )AF, integerLDAF, real, dimension( ldb, * )B, integerLDB, real, dimension( ldx, * )X, integerLDX,…
NAME spoequb.f – SYNOPSIS Functions/Subroutines subroutine spoequb (N, A, LDA, S, SCOND, AMAX, INFO) SPOEQUB Function/Subroutine Documentation subroutine spoequb (integerN, real, dimension( lda, * )A, integerLDA, real, dimension( * )S, realSCOND, realAMAX, integerINFO) SPOEQUB Purpose: SPOEQU computes row and column scalings intended to equilibrate a symmetric positive definite matrix A and reduce its condition number…
NAME spoequ.f – SYNOPSIS Functions/Subroutines subroutine spoequ (N, A, LDA, S, SCOND, AMAX, INFO) SPOEQU Function/Subroutine Documentation subroutine spoequ (integerN, real, dimension( lda, * )A, integerLDA, real, dimension( * )S, realSCOND, realAMAX, integerINFO) SPOEQU Purpose: SPOEQU computes row and column scalings intended to equilibrate a symmetric positive definite matrix A and reduce its condition number…
NAME spocon.f – SYNOPSIS Functions/Subroutines subroutine spocon (UPLO, N, A, LDA, ANORM, RCOND, WORK, IWORK, INFO) SPOCON Function/Subroutine Documentation subroutine spocon (characterUPLO, integerN, real, dimension( lda, * )A, integerLDA, realANORM, realRCOND, real, dimension( * )WORK, integer, dimension( * )IWORK, integerINFO) SPOCON Purpose: SPOCON estimates the reciprocal of the condition number (in the 1-norm) of a…
SPI_scroll_cursor_move – move a cursor Synopsis void SPI_scroll_cursor_move(Portal portal, FetchDirection direction, long count) Description SPI_scroll_cursor_move skips over some number of rows in a cursor. This is equivalent to the SQL command MOVE. Arguments Portal portal portal containing the cursor FetchDirection direction one of FETCH_FORWARD, FETCH_BACKWARD, FETCH_ABSOLUTE or FETCH_RELATIVE long count number of rows to move…
SPI_scroll_cursor_fetch – fetch some rows from a cursor Synopsis void SPI_scroll_cursor_fetch(Portal portal, FetchDirection direction, long count) Description SPI_scroll_cursor_fetch fetches some rows from a cursor. This is equivalent to the SQL command FETCH. Arguments Portal portal portal containing the cursor FetchDirection direction one of FETCH_FORWARD, FETCH_BACKWARD, FETCH_ABSOLUTE or FETCH_RELATIVE long count number of rows to fetch…
SPI_saveplan – save a prepared statement Synopsis SPIPlanPtr SPI_saveplan(SPIPlanPtr plan) Description SPI_saveplan copies a passed statement (prepared by SPI_prepare) into memory that will not be freed by SPI_finish nor by the transaction manager, and returns a pointer to the copied statement. This gives you the ability to reuse prepared statements in the subsequent invocations of…
SPI_returntuple – prepare to return a tuple as a Datum Synopsis HeapTupleHeader SPI_returntuple(HeapTuple row, TupleDesc rowdesc) Description SPI_returntuple makes a copy of a row in the upper executor context, returning it in the form of a row type Datum. The returned pointer need only be converted to Datum via PointerGetDatum before returning. Note that this…
SPI_repalloc – reallocate memory in the upper executor context Synopsis void * SPI_repalloc(void * pointer, Size size) Description SPI_repalloc changes the size of a memory segment previously allocated using SPI_palloc. This function is no longer different from plain repalloc. It’s kept just for backward compatibility of existing code. Arguments void * pointer pointer to existing…
SPI_push – push SPI stack to allow recursive SPI usage Synopsis void SPI_push(void) Description SPI_push should be called before executing another procedure that might itself wish to use SPI. After SPI_push, SPI is no longer in a “connected” state, and SPI function calls will be rejected unless a fresh SPI_connect is done. This ensures a…
SPI_prepare_params – prepare a statement, without executing it yet Synopsis SPIPlanPtr SPI_prepare_params(const char * command, ParserSetupHook parserSetup, void * parserSetupArg, int cursorOptions) Description SPI_prepare_params creates and returns a prepared statement for the specified command, but doesn’t execute the command. This function is equivalent to SPI_prepare_cursor, with the addition that the caller can specify parser hook…
SPI_prepare_cursor – prepare a statement, without executing it yet Synopsis SPIPlanPtr SPI_prepare_cursor(const char * command, int nargs, Oid * argtypes, int cursorOptions) Description SPI_prepare_cursor is identical to SPI_prepare, except that it also allows specification of the planner’s “cursor options” parameter. This is a bit mask having the values shown in nodes/parsenodes.h for the options field…
SPI_prepare – prepare a statement, without executing it yet Synopsis SPIPlanPtr SPI_prepare(const char * command, int nargs, Oid * argtypes) Description SPI_prepare creates and returns a prepared statement for the specified command, but doesn’t execute the command. The prepared statement can later be executed repeatedly using SPI_execute_plan. When the same or a similar command is…
SPI_pop – pop SPI stack to return from recursive SPI usage Synopsis void SPI_pop(void) Description SPI_pop pops the previous environment from the SPI call stack. See SPI_push.
SPI_pfree – free memory in the upper executor context Synopsis void SPI_pfree(void * pointer) Description SPI_pfree frees memory previously allocated using SPI_palloc or SPI_repalloc. This function is no longer different from plain pfree. It’s kept just for backward compatibility of existing code. Arguments void * pointer pointer to existing storage to free
SPI_palloc – allocate memory in the upper executor context Synopsis void * SPI_palloc(Size size) Description SPI_palloc allocates memory in the upper executor context. Arguments Size size size in bytes of storage to allocate Return Value pointer to new storage space of the specified size
SPI_modifytuple – create a row by replacing selected fields of a given row Synopsis HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols, int * colnum, Datum * values, const char * nulls) Description SPI_modifytuple creates a new row by substituting new values for selected columns, copying the original row’s columns at other positions. The input row…
SPI_keepplan – save a prepared statement Synopsis int SPI_keepplan(SPIPlanPtr plan) Description SPI_keepplan saves a passed statement (prepared by SPI_prepare) so that it will not be freed by SPI_finish nor by the transaction manager. This gives you the ability to reuse prepared statements in the subsequent invocations of your procedure in the current session. Arguments SPIPlanPtr…