Search PostgreSQL documentation

SP-GiSTManual ChaptersPG1811.2.4. SP-GiST SP-GiST indexes, like GiST indexes, offer an infrastructure that supports various kinds of searches. SP-GiST permits implementation of a wide range of different non-balanced …SP-GiST SP-GiST IndexesManual ChaptersPG1865.3. SP-GiST IndexesSP-GiST Indexes SP-GiST LimitsManual ChaptersPG1865.3.4.1. SP-GiST Limits Individual leaf tuples and inner tuples must fit on a single index page (8kB by default). Therefore, when indexing values of variable-length data types, long values …SP-GiST Limits SP-GiST Without Node LabelsManual ChaptersPG1865.3.4.2. SP-GiST Without Node Labels Some tree algorithms use a fixed set of nodes for each inner tuple; for example, in a quad-tree there are always exactly four nodes corresponding to the…SP-GiST Without Node Labels Special CharactersManual ChaptersPG184.1.4. Special Characters Some characters that are not alphanumeric have a special meaning that is different from being an operator. Details on the usage can be found at the location where t…Special Characters Special Considerations for 64-Bit WindowsManual ChaptersPG1817.7.5.2. Special Considerations for 64-Bit Windows PostgreSQL will only build for the x64 architecture on 64-bit Windows. Mixing 32- and 64-bit versions in the same build tree is not suppor…Special Considerations for 64-Bit Windows Special Constants of pgtypeslibManual ChaptersPG1834.6.8. Special Constants of pgtypeslib PGTYPESInvalidTimestamp # A value of type timestamp representing an invalid time stamp. This is returned by the function PGTYPEStimestamp_from_asc on …Special Constants of pgtypeslib Special Features of Operator ClassesManual ChaptersPG1836.16.8. Special Features of Operator Classes There are two special features of operator classes that we have not discussed yet, mainly because they are not useful with the most commonly use…Special Features of Operator Classes Special ValuesManual ChaptersPG188.5.1.4. Special Values PostgreSQL supports several special date/time input values for convenience, as shown in Table 8.13. The values infinity and -infinity are specially represented inside…Special Values Specifying Multiple HostsManual ChaptersPG1832.1.1.3. Specifying Multiple Hosts It is possible to specify multiple hosts to connect to, so that they are tried in the given order. In the Keyword/Value format, the host, hostaddr, and po…Specifying Multiple Hosts spi — Server Programming Interface features/examplesManual ChaptersPG18F.41. spi — Server Programming Interface features/examples The spi module provides several workable examples of using the Server Programming Interface (SPI) and triggers. While these functio…spi — Server Programming Interface features/examples SPI_commitManual ChaptersPG18SPI_commit SPI_commit, SPI_commit_and_chain — commit the current transaction Synopsis void SPI_commit(void) void SPI_commit_and_chain(void)SPI_commit SPI_connectManual ChaptersPG18SPI_connect SPI_connect, SPI_connect_ext — connect a C function to the SPI manager Synopsis int SPI_connect(void) int SPI_connect_ext(int options)SPI_connect SPI_copytupleManual ChaptersPG18SPI_copytuple SPI_copytuple — make a copy of a row in the upper executor context Synopsis HeapTuple SPI_copytuple(HeapTuple row)SPI_copytuple SPI_cursor_closeManual ChaptersPG18SPI_cursor_close SPI_cursor_close — close a cursor Synopsis void SPI_cursor_close(Portal portal)SPI_cursor_close SPI_cursor_fetchManual ChaptersPG18SPI_cursor_fetch SPI_cursor_fetch — fetch some rows from a cursor Synopsis void SPI_cursor_fetch(Portal portal, bool forward, long count)SPI_cursor_fetch SPI_cursor_findManual ChaptersPG18SPI_cursor_find SPI_cursor_find — find an existing cursor by name Synopsis Portal SPI_cursor_find(const char * name)SPI_cursor_find SPI_cursor_moveManual ChaptersPG18SPI_cursor_move SPI_cursor_move — move a cursor Synopsis void SPI_cursor_move(Portal portal, bool forward, long count)SPI_cursor_move SPI_cursor_openManual ChaptersPG18SPI_cursor_open 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 * …SPI_cursor_open SPI_cursor_open_with_argsManual ChaptersPG18SPI_cursor_open_with_args 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,…SPI_cursor_open_with_args SPI_cursor_open_with_paramlistManual ChaptersPG18SPI_cursor_open_with_paramlist SPI_cursor_open_with_paramlist — set up a cursor using parameters Synopsis Portal SPI_cursor_open_with_paramlist(const char *name, SPIPlanPtr plan, ParamListIn…SPI_cursor_open_with_paramlist SPI_cursor_parse_openManual ChaptersPG18SPI_cursor_parse_open SPI_cursor_parse_open — set up a cursor using a query string and parameters Synopsis Portal SPI_cursor_parse_open(const char *name, const char *command, const SPIParseO…SPI_cursor_parse_open SPI_execManual ChaptersPG18SPI_exec SPI_exec — execute a read/write command Synopsis int SPI_exec(const char * command, long count)SPI_exec SPI_execpManual ChaptersPG18SPI_execp SPI_execp — execute a statement in read/write mode Synopsis int SPI_execp(SPIPlanPtr plan, Datum * values, const char * nulls, long count)SPI_execp SPI_executeManual ChaptersPG18SPI_execute SPI_execute — execute a command Synopsis int SPI_execute(const char * command, bool read_only, long count)SPI_execute SPI_execute_extendedManual ChaptersPG18SPI_execute_extended SPI_execute_extended — execute a command with out-of-line parameters Synopsis int SPI_execute_extended(const char *command, const SPIExecuteOptions * options)SPI_execute_extended SPI_execute_planManual ChaptersPG18SPI_execute_plan 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)SPI_execute_plan SPI_execute_plan_extendedManual ChaptersPG18SPI_execute_plan_extended SPI_execute_plan_extended — execute a statement prepared by SPI_prepare Synopsis int SPI_execute_plan_extended(SPIPlanPtr plan, const SPIExecuteOptions * options)SPI_execute_plan_extended SPI_execute_plan_with_paramlistManual ChaptersPG18SPI_execute_plan_with_paramlist SPI_execute_plan_with_paramlist — execute a statement prepared by SPI_prepare Synopsis int SPI_execute_plan_with_paramlist(SPIPlanPtr plan, ParamListInfo para…SPI_execute_plan_with_paramlist SPI_execute_with_argsManual ChaptersPG18SPI_execute_with_args SPI_execute_with_args — execute a command with out-of-line parameters Synopsis int SPI_execute_with_args(const char *command, int nargs, Oid *argtypes, Datum *values, c…SPI_execute_with_args SPI_finishManual ChaptersPG18SPI_finish SPI_finish — disconnect a C function from the SPI manager Synopsis int SPI_finish(void)SPI_finish SPI_fnameManual ChaptersPG18SPI_fname SPI_fname — determine the column name for the specified column number Synopsis char * SPI_fname(TupleDesc rowdesc, int colnumber)SPI_fname SPI_fnumberManual ChaptersPG18SPI_fnumber SPI_fnumber — determine the column number for the specified column name Synopsis int SPI_fnumber(TupleDesc rowdesc, const char * colname)SPI_fnumber SPI_freeplanManual ChaptersPG18SPI_freeplan SPI_freeplan — free a previously saved prepared statement Synopsis int SPI_freeplan(SPIPlanPtr plan)SPI_freeplan SPI_freetupleManual ChaptersPG18SPI_freetuple SPI_freetuple — free a row allocated in the upper executor context Synopsis void SPI_freetuple(HeapTuple row)SPI_freetuple SPI_freetuptableManual ChaptersPG18SPI_freetuptable SPI_freetuptable — free a row set created by SPI_execute or a similar function Synopsis void SPI_freetuptable(SPITupleTable * tuptable)SPI_freetuptable SPI_getargcountManual ChaptersPG18SPI_getargcount SPI_getargcount — return the number of arguments needed by a statement prepared by SPI_prepare Synopsis int SPI_getargcount(SPIPlanPtr plan)SPI_getargcount SPI_getargtypeidManual ChaptersPG18SPI_getargtypeid SPI_getargtypeid — return the data type OID for an argument of a statement prepared by SPI_prepare Synopsis Oid SPI_getargtypeid(SPIPlanPtr plan, int argIndex)SPI_getargtypeid SPI_getbinvalManual ChaptersPG18SPI_getbinval SPI_getbinval — return the binary value of the specified column Synopsis Datum SPI_getbinval(HeapTuple row, TupleDesc rowdesc, int colnumber, bool * isnull)SPI_getbinval SPI_getnspnameManual ChaptersPG18SPI_getnspname SPI_getnspname — return the namespace of the specified relation Synopsis char * SPI_getnspname(Relation rel)SPI_getnspname