SPI_exec – execute a read/write command Synopsis int SPI_exec(const char * command, long count) Description SPI_exec is the same as SPI_execute, with the latter’s read_only parameter always taken as false. Arguments const char * command string containing command to execute long count maximum number of rows to return, or 0 for no limit Return Value…
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…
SPI_cursor_open_with_args – set up a cursor using a query and parameters Synopsis Portal SPI_cursor_open_with_args(const char *name, const char *command, int nargs, Oid *argtypes, Datum *values, const char *nulls, bool read_only, int cursorOptions) Description SPI_cursor_open_with_args sets up a cursor (internally, a portal) that will execute the specified query. Most of the parameters have the same meanings…
SPI_cursor_open – set up a cursor using a statement created with SPI_prepare Synopsis Portal SPI_cursor_open(const char * name, SPIPlanPtr plan, Datum * values, const char * nulls, bool read_only) Description SPI_cursor_open sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. The parameters have the same meanings as the corresponding…
SPI_cursor_move – move a cursor Synopsis void SPI_cursor_move(Portal portal, bool forward, long count) Description SPI_cursor_move skips over some number of rows in a cursor. This is equivalent to a subset of the SQL command MOVE (see SPI_scroll_cursor_move for more functionality). Arguments Portal portal portal containing the cursor bool forward true for move forward, false for…
SPI_cursor_find – find an existing cursor by name Synopsis Portal SPI_cursor_find(const char * name) Description SPI_cursor_find finds an existing portal by name. This is primarily useful to resolve a cursor name returned as text by some other function. Arguments const char * name name of the portal Return Value pointer to the portal with the…
SPI_cursor_fetch – fetch some rows from a cursor Synopsis void SPI_cursor_fetch(Portal portal, bool forward, long count) Description SPI_cursor_fetch fetches some rows from a cursor. This is equivalent to a subset of the SQL command FETCH (see SPI_scroll_cursor_fetch for more functionality). Arguments Portal portal portal containing the cursor bool forward true for fetch forward, false for…
SPI_cursor_close – close a cursor Synopsis void SPI_cursor_close(Portal portal) Description SPI_cursor_close closes a previously created cursor and releases its portal storage. All open cursors are closed automatically at the end of a transaction. SPI_cursor_close need only be invoked if it is desirable to release resources sooner. Arguments Portal portal portal containing the cursor
SPI_copytuple – make a copy of a row in the upper executor context Synopsis HeapTuple SPI_copytuple(HeapTuple row) Description SPI_copytuple makes a copy of a row in the upper executor context. This is normally used to return a modified row from a trigger. In a function declared to return a composite type, use SPI_returntuple instead. Arguments…
SPI_connect – connect a procedure to the SPI manager Synopsis int SPI_connect(void) Description SPI_connect opens a connection from a procedure invocation to the SPI manager. You must call this function if you want to execute commands through SPI. Some utility SPI functions can be called from unconnected procedures. If your procedure is already connected, SPI_connect…
NAME spftrs.f – SYNOPSIS Functions/Subroutines subroutine spftrs (TRANSR, UPLO, N, NRHS, A, B, LDB, INFO) SPFTRS Function/Subroutine Documentation subroutine spftrs (characterTRANSR, characterUPLO, integerN, integerNRHS, real, dimension( 0: * )A, real, dimension( ldb, * )B, integerLDB, integerINFO) SPFTRS Purpose: SPFTRS solves a system of linear equations A*X = B with a symmetric positive definite matrix A…
NAME spftri.f – SYNOPSIS Functions/Subroutines subroutine spftri (TRANSR, UPLO, N, A, INFO) SPFTRI Function/Subroutine Documentation subroutine spftri (characterTRANSR, characterUPLO, integerN, real, dimension( 0: * )A, integerINFO) SPFTRI Purpose: SPFTRI computes the inverse of a real (symmetric) positive definite matrix A using the Cholesky factorization A = U**T*U or A = L*L**T computed by SPFTRF. …
NAME spftrf.f – SYNOPSIS Functions/Subroutines subroutine spftrf (TRANSR, UPLO, N, A, INFO) SPFTRF Function/Subroutine Documentation subroutine spftrf (characterTRANSR, characterUPLO, integerN, real, dimension( 0: * )A, integerINFO) SPFTRF Purpose: SPFTRF computes the Cholesky factorization of a real symmetric positive definite matrix A. The factorization has the form A = U**T * U, if UPLO = ‘U’,…
NAME spbtrs.f – SYNOPSIS Functions/Subroutines subroutine spbtrs (UPLO, N, KD, NRHS, AB, LDAB, B, LDB, INFO) SPBTRS Function/Subroutine Documentation subroutine spbtrs (characterUPLO, integerN, integerKD, integerNRHS, real, dimension( ldab, * )AB, integerLDAB, real, dimension( ldb, * )B, integerLDB, integerINFO) SPBTRS Purpose: SPBTRS solves a system of linear equations A*X = B with a symmetric positive definite…
NAME spbtrf.f – SYNOPSIS Functions/Subroutines subroutine spbtrf (UPLO, N, KD, AB, LDAB, INFO) SPBTRF Function/Subroutine Documentation subroutine spbtrf (characterUPLO, integerN, integerKD, real, dimension( ldab, * )AB, integerLDAB, integerINFO) SPBTRF Purpose: SPBTRF computes the Cholesky factorization of a real symmetric positive definite band matrix A. The factorization has the form A = U**T * U, if…
NAME spbtf2.f – SYNOPSIS Functions/Subroutines subroutine spbtf2 (UPLO, N, KD, AB, LDAB, INFO) SPBTF2 computes the Cholesky factorization of a symmetric/Hermitian positive definite band matrix (unblocked algorithm). Function/Subroutine Documentation subroutine spbtf2 (characterUPLO, integerN, integerKD, real, dimension( ldab, * )AB, integerLDAB, integerINFO) SPBTF2 computes the Cholesky factorization of a symmetric/Hermitian positive definite band matrix (unblocked algorithm)….
spbsvx.f – Synopsis Functions/Subroutines subroutine spbsvx (FACT, UPLO, N, KD, NRHS, AB, LDAB, AFB, LDAFB, EQUED, S, B, LDB, X, LDX, RCOND, FERR, BERR, WORK, IWORK, INFO) SPBSVX computes the solution to system of linear equations A * X = B for OTHER matrices Function/Subroutine Documentation subroutine spbsvx (characterFACT, characterUPLO, integerN, integerKD, integerNRHS, real, dimension(…
spbsv.f – Synopsis Functions/Subroutines subroutine spbsv (UPLO, N, KD, NRHS, AB, LDAB, B, LDB, INFO) SPBSV computes the solution to system of linear equations A * X = B for OTHER matrices Function/Subroutine Documentation subroutine spbsv (characterUPLO, integerN, integerKD, integerNRHS, real, dimension( ldab, * )AB, integerLDAB, real, dimension( ldb, * )B, integerLDB, integerINFO) SPBSV computes…
NAME spbstf.f – SYNOPSIS Functions/Subroutines subroutine spbstf (UPLO, N, KD, AB, LDAB, INFO) SPBSTF Function/Subroutine Documentation subroutine spbstf (characterUPLO, integerN, integerKD, real, dimension( ldab, * )AB, integerLDAB, integerINFO) SPBSTF Purpose: SPBSTF computes a split Cholesky factorization of a real symmetric positive definite band matrix A. This routine is designed to be used in conjunction with…
NAME spbrfs.f – SYNOPSIS Functions/Subroutines subroutine spbrfs (UPLO, N, KD, NRHS, AB, LDAB, AFB, LDAFB, B, LDB, X, LDX, FERR, BERR, WORK, IWORK, INFO) SPBRFS Function/Subroutine Documentation subroutine spbrfs (characterUPLO, integerN, integerKD, integerNRHS, real, dimension( ldab, * )AB, integerLDAB, real, dimension( ldafb, * )AFB, integerLDAFB, real, dimension( ldb, * )B, integerLDB, real, dimension( ldx, *…