<HTML ><HEAD ><TITLE >Index</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.73 "><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 7.3.2 Documentation" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Style Guide" HREF="doc-style.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META NAME="creation" CONTENT="2003-02-03T20:17:34"></HEAD ><BODY CLASS="SETINDEX" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PostgreSQL 7.3.2 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="doc-style.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" > </TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="SETINDEX" >Index</A ></H1 ><H2 CLASS="INDEXDIV" ><A NAME="AEN56859" >Symbols</A ></H2 ><DL ><DT >$libdir, <A HREF="xfunc-c.html#XFUNC-C-DYNLOAD" >Dynamic Loading</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN56864" >A</A ></H2 ><DL ><DT >aggregate, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >aggregate functions, <A HREF="sql-expressions.html#SYNTAX-AGGREGATES" >Aggregate Expressions</A > </DT ><DD ><DL ><DT >extending, <A HREF="xaggr.html" >Extending SQL: Aggregates</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >alias </DT ><DD ><DL ><DT >See label</DT ><DT >for table name in query, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ></DL ></DD ><DT >all, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >and </DT ><DD ><DL ><DT >operator, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >any, <A HREF="datatype-pseudo.html" >Pseudo-Types</A >, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >anyarray, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >arrays, <A HREF="arrays.html" >Arrays</A >, <A HREF="xtypes.html" >Extending SQL: Types</A > </DT ><DD ><DL ><DT >constants, <A HREF="sql-syntax.html#AEN1253" >Array constants</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >Australian time zones, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >auto-increment </DT ><DD ><DL ><DT >See serial</DT ></DL ></DD ><DT >autocommit, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >average, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DD ><DL ><DT >function, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN56913" >B</A ></H2 ><DL ><DT >B-tree </DT ><DD ><DL ><DT >See indexes</DT ></DL ></DD ><DT >backup, <A HREF="backup.html" >Backup and Restore</A > </DT ><DT >between, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DT >bigint, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >bigserial, <A HREF="datatype.html#DATATYPE-SERIAL" >The Serial Types</A > </DT ><DT >binary strings </DT ><DD ><DL ><DT >concatenation, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >length, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >bison, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >bit strings </DT ><DD ><DL ><DT >constants, <A HREF="sql-syntax.html#SQL-SYNTAX-BIT-STRINGS" >Bit-String Constants</A > </DT ><DD ><DL ></DL ></DD ><DT >data type, <A HREF="datatype-bit.html" >Bit String Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >BLOB </DT ><DD ><DL ><DT >See large object</DT ></DL ></DD ><DT >Boolean </DT ><DD ><DL ><DT >data type, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DD ><DL ></DL ></DD ><DT >operators </DT ><DD ><DL ><DT >See operators, logical</DT ></DL ></DD ></DL ></DD ><DT >box (data type), <A HREF="datatype-geometric.html#AEN4392" >Box</A > </DT ><DT >BSD/OS, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN56961" >C</A ></H2 ><DL ><DT >case, <A HREF="functions-conditional.html" >Conditional Expressions</A > </DT ><DT >case sensitivity </DT ><DD ><DL ><DT >SQL commands, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >catalogs, <A HREF="pg-system-catalogs.html" >About the PostgreSQL System Catalogs</A > </DT ><DT >character set encoding, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >character strings </DT ><DD ><DL ><DT >concatenation, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >constants, <A HREF="sql-syntax.html#SQL-SYNTAX-STRINGS" >String Constants</A > </DT ><DD ><DL ></DL ></DD ><DT >data types, <A HREF="datatype-character.html" >Character Types</A > </DT ><DD ><DL ></DL ></DD ><DT >length, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >cid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >cidr, <A HREF="datatype-net-types.html#DATATYPE-CIDR" >cidr</A > </DT ><DT >circle, <A HREF="datatype-geometric.html#AEN4498" >Circle</A > </DT ><DT >client authentication, <A HREF="client-authentication.html" >Client Authentication</A > </DT ><DT >cluster, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >column, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >columns </DT ><DD ><DL ><DT >system columns, <A HREF="ddl-system-columns.html" >System Columns</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >col_description, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >comments </DT ><DD ><DL ><DT >in SQL, <A HREF="sql-syntax.html#SQL-SYNTAX-COMMENTS" >Comments</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >comparison </DT ><DD ><DL ><DT >operators, <A HREF="functions-comparison.html" >Comparison Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >concurrency, <A HREF="mvcc.html" >Concurrency Control</A > </DT ><DT >conditionals, <A HREF="functions-conditional.html" >Conditional Expressions</A > </DT ><DT >configuration </DT ><DD ><DL ><DT >server, <A HREF="runtime-config.html" >Run-time Configuration</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >configure, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DT >connection loss, <A HREF="pgtcl-pgon-connection-loss.html" >pg_on_connection_loss</A > </DT ><DT >constants, <A HREF="sql-syntax.html#SQL-SYNTAX-CONSTANTS" >Constants</A > </DT ><DT >COPY, <A HREF="tutorial-populate.html" >Populating a Table With Rows</A > </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq-copy.html" >Functions Associated with the COPY Command</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >count, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >CREATE TABLE, <A HREF="tutorial-table.html" >Creating a New Table</A > </DT ><DT >createdb, <A HREF="tutorial-createdb.html" >Creating a Database</A > </DT ><DT >crypt, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DT >cstring, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >currval, <A HREF="functions-sequence.html" >Sequence-Manipulation Functions</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57061" >D</A ></H2 ><DL ><DT >data area </DT ><DD ><DL ><DT >See database cluster</DT ></DL ></DD ><DT >data types, <A HREF="datatype.html" >Data Types</A >, <A HREF="type-system.html" >The PostgreSQL Type System</A > </DT ><DD ><DL ><DT >constants, <A HREF="sql-syntax.html#SQL-SYNTAX-CONSTANTS-GENERIC" >Constants of Other Types</A > </DT ><DD ><DL ></DL ></DD ><DT >extending, <A HREF="xtypes.html" >Extending SQL: Types</A > </DT ><DD ><DL ></DL ></DD ><DT >numeric, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DD ><DL ></DL ></DD ><DT >type casts, <A HREF="sql-expressions.html#SQL-SYNTAX-TYPE-CASTS" >Type Casts</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >database, <A HREF="managing-databases.html" >Managing Databases</A > </DT ><DD ><DL ><DT >creating, <A HREF="tutorial-createdb.html" >Creating a Database</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >database cluster, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DT >date </DT ><DD ><DL ><DT >constants, <A HREF="datatype-datetime.html#AEN4001" >Special values</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-CURRENT" >Current Date/Time</A > </DT ><DD ><DL ></DL ></DD ><DT >data type, <A HREF="datatype-datetime.html#AEN3772" >Dates</A > </DT ><DD ><DL ></DL ></DD ><DT >output format, <A HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT" >Date/Time Output</A > </DT ><DD ><DL ><DT >See also Formatting</DT ></DL ></DD ></DL ></DD ><DT >date style, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >deadlock </DT ><DD ><DL ><DT >timeout, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >decimal </DT ><DD ><DL ><DT >See numeric</DT ></DL ></DD ><DT >DELETE, <A HREF="tutorial-delete.html" >Deletions</A > </DT ><DT >Digital UNIX </DT ><DD ><DL ><DT >See Tru64 UNIX</DT ></DL ></DD ><DT >dirty read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >disk space, <A HREF="routine-vacuuming.html#VACUUM-FOR-SPACE-RECOVERY" >Recovering disk space</A > </DT ><DT >disk usage, <A HREF="diskusage.html#DISK-USAGE" >Determining Disk Usage</A > </DT ><DT >DISTINCT, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="queries-select-lists.html#QUERIES-DISTINCT" >DISTINCT</A > </DT ><DT >double precision, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >DROP TABLE, <A HREF="tutorial-table.html" >Creating a New Table</A > </DT ><DT >duplicate, <A HREF="tutorial-select.html" >Querying a Table</A > </DT ><DT >dynamic loading, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >dynamic_library_path, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A >, <A HREF="xfunc-c.html#XFUNC-C-DYNLOAD" >Dynamic Loading</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57142" >E</A ></H2 ><DL ><DT >elog, <A HREF="pltcl-description.html#AEN36642" >Database Access from PL/Tcl</A > </DT ><DD ><DL ><DT >PL/Perl, <A HREF="plperl-database.html" >Database Access from PL/Perl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >embedded SQL </DT ><DD ><DL ><DT >in C, <A HREF="ecpg.html" >ECPG - Embedded SQL in C</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >environment variables, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >error message, <A HREF="libpq-connect.html" >Database Connection Functions</A > </DT ><DT >escaping binary strings, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA" >Escaping binary strings for inclusion in SQL queries</A > </DT ><DT >escaping strings, <A HREF="libpq-exec.html#LIBPQ-EXEC-ESCAPE-STRING" >Escaping strings for inclusion in SQL queries</A > </DT ><DT >except, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >exists, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >extending SQL, <A HREF="extend.html" >Extending SQL: An Overview</A > </DT ><DD ><DL ><DT >types, <A HREF="type-system.html" >The PostgreSQL Type System</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57176" >F</A ></H2 ><DL ><DT >false, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DT >FETCH </DT ><DD ><DL ><DT >embedded SQL, <A HREF="ecpg-porting.html" >Porting From Other RDBMS Packages</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >files, <A HREF="libpq-files.html" >Files</A > </DT ><DT >flex, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >float4 </DT ><DD ><DL ><DT >See real</DT ></DL ></DD ><DT >float8 </DT ><DD ><DL ><DT >See double precision</DT ></DL ></DD ><DT >floating point, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >foreign key, <A HREF="tutorial-fk.html" >Foreign Keys</A > </DT ><DT >formatting, <A HREF="functions-formatting.html" >Data Type Formatting Functions</A > </DT ><DT >FreeBSD, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >fsync, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >function, <A HREF="xfunc.html" >Extending SQL: Functions</A >, <A HREF="xfunc-tablefunctions.html" >Table Functions</A > </DT ><DD ><DL ><DT >internal, <A HREF="xfunc-internal.html" >Internal Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >SQL, <A HREF="xfunc-sql.html" >Query Language (SQL) Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >functions, <A HREF="functions.html" >Functions and Operators</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57225" >G</A ></H2 ><DL ><DT >genetic query optimization, <A HREF="runtime-config.html#RUNTIME-CONFIG-OPTIMIZER" >Planner and Optimizer Tuning</A > </DT ><DT >GEQO </DT ><DD ><DL ><DT >See genetic query optimization</DT ></DL ></DD ><DT >get_bit, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >get_byte, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >group, <A HREF="queries-table-expressions.html#QUERIES-GROUP" >The GROUP BY and HAVING Clauses</A > </DT ><DT >GROUP BY, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57245" >H</A ></H2 ><DL ><DT >hash </DT ><DD ><DL ><DT >See indexes</DT ></DL ></DD ><DT >has_database_privilege, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >has_function_privilege, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >has_language_privilege, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >has_schema_privilege, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >has_table_privilege, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >HAVING, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >hierarchical database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >HP-UX, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57275" >I</A ></H2 ><DL ><DT >ident, <A HREF="auth-methods.html#AUTH-IDENT" >Ident-based authentication</A > </DT ><DT >identifiers, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DT >in, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >index scan, <A HREF="runtime-config.html#RUNTIME-CONFIG-OPTIMIZER" >Planner and Optimizer Tuning</A > </DT ><DT >indexes, <A HREF="indexes.html" >Indexes</A > </DT ><DD ><DL ><DT >B-tree, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >hash, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >multicolumn, <A HREF="indexes-multicolumn.html" >Multicolumn Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >on functions, <A HREF="indexes-functional.html" >Functional Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >partial, <A HREF="indexes-partial.html" >Partial Indexes</A > </DT ><DD ><DL ></DL ></DD ><DT >R-tree, <A HREF="indexes-types.html" >Index Types</A > </DT ><DD ><DL ></DL ></DD ><DT >unique, <A HREF="indexes-unique.html" >Unique Indexes</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >inet (data type), <A HREF="datatype-net-types.html#DATATYPE-INET" >inet</A > </DT ><DT >inheritance, <A HREF="tutorial-inheritance.html" >Inheritance</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >initlocation, <A HREF="manage-ag-alternate-locs.html" >Alternative Locations</A > </DT ><DT >input function, <A HREF="xtypes.html" >Extending SQL: Types</A > </DT ><DT >INSERT, <A HREF="tutorial-populate.html" >Populating a Table With Rows</A > </DT ><DT >installation, <A HREF="installation.html" > Installation Instructions</A > </DT ><DD ><DL ><DT >on Windows, <A HREF="install-requirements.html" >Requirements</A >, <A HREF="install-win32.html" >Installation on Windows</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >int2 </DT ><DD ><DL ><DT >See smallint</DT ></DL ></DD ><DT >int4 </DT ><DD ><DL ><DT >See integer</DT ></DL ></DD ><DT >int8 </DT ><DD ><DL ><DT >See bigint</DT ></DL ></DD ><DT >integer, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >internal, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >intersection, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >interval, <A HREF="datatype-datetime.html#AEN3974" >Intervals</A > </DT ><DT >IRIX, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >IS NULL, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >isolation levels, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DD ><DL ><DT >read committed, <A HREF="transaction-iso.html#XACT-READ-COMMITTED" >Read Committed Isolation Level</A > </DT ><DD ><DL ></DL ></DD ><DT >read serializable, <A HREF="transaction-iso.html#XACT-SERIALIZABLE" >Serializable Isolation Level</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57362" >J</A ></H2 ><DL ><DT >join, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ><DD ><DL ><DT >outer, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >self, <A HREF="tutorial-join.html" >Joins Between Tables</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >joins, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ><DT >cross, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >left, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >natural, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ><DT >outer, <A HREF="queries-table-expressions.html#QUERIES-JOIN" >Joined Tables</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57382" >K</A ></H2 ><DL ><DT >Kerberos, <A HREF="auth-methods.html#KERBEROS-AUTH" >Kerberos authentication</A > </DT ><DT >key words </DT ><DD ><DL ><DT >list of, <A HREF="sql-keywords-appendix.html" >SQL Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57393" >L</A ></H2 ><DL ><DT >label </DT ><DD ><DL ><DT >column, <A HREF="queries-select-lists.html#QUERIES-COLUMN-LABELS" >Column Labels</A > </DT ><DD ><DL ></DL ></DD ><DT >table, <A HREF="queries-table-expressions.html#QUERIES-TABLE-ALIASES" >Table and Column Aliases</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >language_handler, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >large object, <A HREF="largeobjects.html" >Large Objects</A > </DT ><DT >LC_COLLATE, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DT >ldconfig, <A HREF="install-post.html#AEN18587" >Shared Libraries</A > </DT ><DT >length </DT ><DD ><DL ><DT >binary strings </DT ><DD ><DL ><DT >See binary strings, length</DT ></DL ></DD ><DT >character strings </DT ><DD ><DL ><DT >See character strings, length</DT ></DL ></DD ></DL ></DD ><DT >libperl, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >libpgtcl, <A HREF="pgtcl.html" >pgtcl - Tcl Binding Library</A > </DT ><DT >libpq, <A HREF="libpq.html" >libpq - C Library</A > </DT ><DT >libpq-fe.h, <A HREF="libpq-connect.html" >Database Connection Functions</A > </DT ><DT >libpq-int.h, <A HREF="libpq-connect.html" >Database Connection Functions</A >, <A HREF="libpq-build.html" >Building Libpq Programs</A > </DT ><DT >libpython, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >like, <A HREF="functions-matching.html#FUNCTIONS-LIKE" >LIKE</A > </DT ><DT >limit, <A HREF="queries-limit.html" >LIMIT and OFFSET</A > </DT ><DT >line, <A HREF="datatype-geometric.html#AEN4362" >Line Segment</A > </DT ><DT >Linux, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >locale, <A HREF="creating-cluster.html" >Creating a Database Cluster</A >, <A HREF="charset.html#LOCALE" >Locale Support</A > </DT ><DT >locking, <A HREF="explicit-locking.html" >Explicit Locking</A > </DT ><DT >log files, <A HREF="logfile-maintenance.html" >Log File Maintenance</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57462" >M</A ></H2 ><DL ><DT >MAC address </DT ><DD ><DL ><DT >See macaddr</DT ></DL ></DD ><DT >macaddr (data type), <A HREF="datatype-net-types.html#DATATYPE-MACADDR" >macaddr</A > </DT ><DT >MacOS X, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >make, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >MANPATH, <A HREF="install-post.html#AEN18644" >Environment Variables</A > </DT ><DD ><DL ><DT >See also man pages</DT ></DL ></DD ><DT >max, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >MD5, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DT >min, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >multibyte, <A HREF="multibyte.html" >Multibyte Support</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57493" >N</A ></H2 ><DL ><DT >names </DT ><DD ><DL ><DT >qualified, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DD ><DL ></DL ></DD ><DT >unqualified, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >namespaces, <A HREF="ddl-schemas.html" >Schemas</A >, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >NetBSD, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >network </DT ><DD ><DL ><DT >addresses, <A HREF="datatype-net-types.html" >Network Address Data Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >nextval, <A HREF="functions-sequence.html" >Sequence-Manipulation Functions</A > </DT ><DT >nonblocking connection, <A HREF="libpq-connect.html" >Database Connection Functions</A >, <A HREF="libpq-async.html" >Asynchronous Query Processing</A > </DT ><DT >nonrepeatable read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >not </DT ><DD ><DL ><DT >operator, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >not in, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >notice processor, <A HREF="libpq-control.html" >libpq Control Functions</A > </DT ><DT >NOTIFY, <A HREF="libpq-notify.html" >Asynchronous Notification</A >, <A HREF="pgtcl-pglisten.html" >pg_listen</A > </DT ><DT >nullif, <A HREF="functions-conditional.html#AEN9836" >NULLIF</A > </DT ><DT >numeric </DT ><DD ><DL ><DT >constants, <A HREF="sql-syntax.html#AEN1185" >Numeric Constants</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >numeric (data type), <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57548" >O</A ></H2 ><DL ><DT >object identifier </DT ><DD ><DL ><DT >data type, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >object-oriented database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >obj_description, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >offset </DT ><DD ><DL ><DT >with query results, <A HREF="queries-limit.html" >LIMIT and OFFSET</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >OID, <A HREF="ddl-system-columns.html" >System Columns</A >, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >opaque, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >OpenBSD, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >OpenSSL, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DD ><DL ><DT >See also SSL</DT ></DL ></DD ><DT >operators, <A HREF="functions.html" >Functions and Operators</A > </DT ><DD ><DL ><DT >logical, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DD ><DL ></DL ></DD ><DT >precedence, <A HREF="sql-syntax.html#SQL-PRECEDENCE" >Lexical Precedence</A > </DT ><DD ><DL ></DL ></DD ><DT >syntax, <A HREF="sql-syntax.html#SQL-SYNTAX-OPERATORS" >Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >or </DT ><DD ><DL ><DT >operator, <A HREF="functions.html#FUNCTIONS-LOGICAL" >Logical Operators</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >Oracle, <A HREF="ecpg-porting.html" >Porting From Other RDBMS Packages</A >, <A HREF="plpgsql-porting.html" >Porting from Oracle PL/SQL</A > </DT ><DT >ORDER BY, <A HREF="tutorial-select.html" >Querying a Table</A >, <A HREF="charset.html#AEN21740" >Benefits</A > </DT ><DT >output function, <A HREF="xtypes.html" >Extending SQL: Types</A > </DT ><DT >overlay, <A HREF="functions-string.html" >String Functions and Operators</A > </DT ><DT >overloading, <A HREF="xfunc-overload.html" >Function Overloading</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57610" >P</A ></H2 ><DL ><DT >password, <A HREF="auth-methods.html#AUTH-PASSWORD" >Password authentication</A > </DT ><DD ><DL ><DT >.pgpass, <A HREF="libpq-files.html" >Files</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PATH, <A HREF="install-post.html#AEN18644" >Environment Variables</A > </DT ><DT >path (data type), <A HREF="datatype-geometric.html#AEN4422" >Path</A > </DT ><DT >Perl, <A HREF="plperl.html" >PL/Perl - Perl Procedural Language</A > </DT ><DT >PGDATA, <A HREF="creating-cluster.html" >Creating a Database Cluster</A > </DT ><DT >PGDATABASE, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGHOST, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGPASSWORD, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >PGPORT, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >pgtcl </DT ><DD ><DL ><DT >closing, <A HREF="pgtcl-pgloclose.html" >pg_lo_close</A > </DT ><DD ><DL ></DL ></DD ><DT >connecting, <A HREF="pgtcl-pgconnect.html" >pg_connect</A >, <A HREF="pgtcl-pgdisconnect.html" >pg_disconnect</A >, <A HREF="pgtcl-pgconndefaults.html" >pg_conndefaults</A >, <A HREF="pgtcl-pgexec.html" >pg_exec</A >, <A HREF="pgtcl-pgresult.html" >pg_result</A >, <A HREF="pgtcl-pgselect.html" >pg_select</A > </DT ><DD ><DL ></DL ></DD ><DT >connection loss, <A HREF="pgtcl-pgon-connection-loss.html" >pg_on_connection_loss</A > </DT ><DD ><DL ></DL ></DD ><DT >creating, <A HREF="pgtcl-pglocreat.html" >pg_lo_creat</A > </DT ><DD ><DL ></DL ></DD ><DT >delete, <A HREF="pgtcl-pglounlink.html" >pg_lo_unlink</A > </DT ><DD ><DL ></DL ></DD ><DT >export, <A HREF="pgtcl-pgloexport.html" >pg_lo_export</A > </DT ><DD ><DL ></DL ></DD ><DT >import, <A HREF="pgtcl-pgloimport.html" >pg_lo_import</A > </DT ><DD ><DL ></DL ></DD ><DT >notify, <A HREF="pgtcl-pglisten.html" >pg_listen</A > </DT ><DD ><DL ></DL ></DD ><DT >opening, <A HREF="pgtcl-pgloopen.html" >pg_lo_open</A > </DT ><DD ><DL ></DL ></DD ><DT >positioning, <A HREF="pgtcl-pglolseek.html" >pg_lo_lseek</A >, <A HREF="pgtcl-pglotell.html" >pg_lo_tell</A > </DT ><DD ><DL ></DL ></DD ><DT >query, <A HREF="pgtcl-pgexecute.html" >pg_execute</A > </DT ><DD ><DL ></DL ></DD ><DT >reading, <A HREF="pgtcl-pgloread.html" >pg_lo_read</A > </DT ><DD ><DL ></DL ></DD ><DT >writing, <A HREF="pgtcl-pglowrite.html" >pg_lo_write</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >PGUSER, <A HREF="libpq-envars.html" >Environment Variables</A > </DT ><DT >pg_config, <A HREF="libpq-build.html" >Building Libpq Programs</A >, <A HREF="xfunc-c.html#AEN32016" >Writing Code</A > </DT ><DT >pg_conndefaults, <A HREF="pgtcl-pgconndefaults.html" >pg_conndefaults</A > </DT ><DT >pg_connect, <A HREF="pgtcl-pgconnect.html" >pg_connect</A >, <A HREF="pgtcl-pgdisconnect.html" >pg_disconnect</A >, <A HREF="pgtcl-pgexec.html" >pg_exec</A >, <A HREF="pgtcl-pgresult.html" >pg_result</A >, <A HREF="pgtcl-pgselect.html" >pg_select</A > </DT ><DT >pg_ctl, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DT >pg_dumpall, <A HREF="install-upgrading.html" >If You Are Upgrading</A > </DT ><DT >pg_execute, <A HREF="pgtcl-pgexecute.html" >pg_execute</A > </DT ><DT >pg_function_is_visible, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_get_constraintdef, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_get_indexdef, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_get_ruledef, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_get_userbyid, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_get_viewdef, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_hba.conf, <A HREF="client-authentication.html#AUTH-PG-HBA-CONF" >The pg_hba.conf file</A > </DT ><DT >pg_ident.conf, <A HREF="auth-methods.html#AEN21569" >Ident Maps</A > </DT ><DT >pg_lo_close, <A HREF="pgtcl-pgloclose.html" >pg_lo_close</A > </DT ><DT >pg_lo_creat, <A HREF="pgtcl-pglocreat.html" >pg_lo_creat</A > </DT ><DT >pg_lo_export, <A HREF="pgtcl-pgloexport.html" >pg_lo_export</A > </DT ><DT >pg_lo_import, <A HREF="pgtcl-pgloimport.html" >pg_lo_import</A > </DT ><DT >pg_lo_lseek, <A HREF="pgtcl-pglolseek.html" >pg_lo_lseek</A > </DT ><DT >pg_lo_open, <A HREF="pgtcl-pgloopen.html" >pg_lo_open</A > </DT ><DT >pg_lo_read, <A HREF="pgtcl-pgloread.html" >pg_lo_read</A > </DT ><DT >pg_lo_tell, <A HREF="pgtcl-pglotell.html" >pg_lo_tell</A > </DT ><DT >pg_lo_unlink, <A HREF="pgtcl-pglounlink.html" >pg_lo_unlink</A > </DT ><DT >pg_lo_write, <A HREF="pgtcl-pglowrite.html" >pg_lo_write</A > </DT ><DT >pg_opclass_is_visible, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_operator_is_visible, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_table_is_visible, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >pg_type_is_visible, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >phantom read, <A HREF="transaction-iso.html" >Transaction Isolation</A > </DT ><DT >PIC, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >PL/Perl, <A HREF="plperl.html" >PL/Perl - Perl Procedural Language</A > </DT ><DT >PL/pgSQL, <A HREF="plpgsql.html" >PL/pgSQL - SQL Procedural Language</A > </DT ><DT >PL/Python, <A HREF="plpython.html" >PL/Python - Python Procedural Language</A > </DT ><DT >PL/SQL, <A HREF="plpgsql-porting.html" >Porting from Oracle PL/SQL</A > </DT ><DT >PL/Tcl, <A HREF="pltcl.html" >PL/Tcl - Tcl Procedural Language</A > </DT ><DT >point, <A HREF="datatype-geometric.html#AEN4340" >Point</A > </DT ><DT >polygon, <A HREF="datatype-geometric.html#AEN4466" >Polygon</A > </DT ><DT >port, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >postgres user, <A HREF="runtime.html#POSTGRES-USER" >The PostgreSQL User Account</A > </DT ><DT >postmaster, <A HREF="tutorial-arch.html" >Architectural Fundamentals</A >, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DT >ps </DT ><DD ><DL ><DT >to monitor activity, <A HREF="monitoring.html#MONITORING-PS" >Standard Unix Tools</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >psql, <A HREF="tutorial-accessdb.html" >Accessing a Database</A > </DT ><DT >Python, <A HREF="plpython.html" >PL/Python - Python Procedural Language</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57814" >Q</A ></H2 ><DL ><DT >qualified names, <A HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE" >Creating a Schema</A > </DT ><DT >query, <A HREF="tutorial-select.html" >Querying a Table</A > </DT ><DT >quotes </DT ><DD ><DL ><DT >and identifiers, <A HREF="sql-syntax.html#SQL-SYNTAX-IDENTIFIERS" >Identifiers and Key Words</A > </DT ><DD ><DL ></DL ></DD ><DT >escaping, <A HREF="sql-syntax.html#SQL-SYNTAX-STRINGS" >String Constants</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57828" >R</A ></H2 ><DL ><DT >R-tree </DT ><DD ><DL ><DT >See indexes</DT ></DL ></DD ><DT >range table, <A HREF="querytree.html#AEN32681" >The Parts of a Query tree</A > </DT ><DT >readline, <A HREF="install-requirements.html" >Requirements</A > </DT ><DT >real, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >record, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >referential integrity, <A HREF="tutorial-fk.html" >Foreign Keys</A > </DT ><DT >regclass, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regoper, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regoperator, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regproc, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regprocedure, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regression test, <A HREF="install-procedure.html" >Installation Procedure</A > </DT ><DT >regtype, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >regular expressions, <A HREF="functions-matching.html#FUNCTIONS-SQL99-REGEXP" >SIMILAR TO and SQL99 Regular Expressions</A >, <A HREF="functions-matching.html#FUNCTIONS-POSIX-REGEXP" >POSIX Regular Expressions</A > </DT ><DD ><DL ><DT >See also pattern matching</DT ></DL ></DD ><DT >reindex, <A HREF="routine-reindex.html" >Routine Reindexing</A > </DT ><DT >relation, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >relational database, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >row, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >rules, <A HREF="rules.html" >The Rule System</A > </DT ><DD ><DL ><DT >and views, <A HREF="rules-views.html" >Views and the Rule System</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN57891" >S</A ></H2 ><DL ><DT >schema </DT ><DD ><DL ><DT >current, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >schemas, <A HREF="ddl-schemas.html" >Schemas</A > </DT ><DD ><DL ><DT >current schema, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SCO OpenServer, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >search path, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DD ><DL ><DT >changing at runtime, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >search_path, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >SELECT, <A HREF="tutorial-select.html" >Querying a Table</A > </DT ><DD ><DL ><DT >select list, <A HREF="queries-select-lists.html" >Select Lists</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >semaphores, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >sequences, <A HREF="functions-sequence.html" >Sequence-Manipulation Functions</A > </DT ><DD ><DL ><DT >and serial type, <A HREF="datatype.html#DATATYPE-SERIAL" >The Serial Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >sequential scan, <A HREF="runtime-config.html#RUNTIME-CONFIG-OPTIMIZER" >Planner and Optimizer Tuning</A > </DT ><DT >serial, <A HREF="datatype.html#DATATYPE-SERIAL" >The Serial Types</A > </DT ><DT >serial4, <A HREF="datatype.html#DATATYPE-SERIAL" >The Serial Types</A > </DT ><DT >serial8, <A HREF="datatype.html#DATATYPE-SERIAL" >The Serial Types</A > </DT ><DT >SETOF, <A HREF="xfunc-sql.html" >Query Language (SQL) Functions</A > </DT ><DD ><DL ><DT >See also function</DT ></DL ></DD ><DT >setting </DT ><DD ><DL ><DT >current, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ><DT >set, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >setval, <A HREF="functions-sequence.html" >Sequence-Manipulation Functions</A > </DT ><DT >set_bit, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >set_byte, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A > </DT ><DT >shared libraries, <A HREF="install-post.html#AEN18587" >Shared Libraries</A > </DT ><DT >shared memory, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >SHMMAX, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A > </DT ><DT >SIGHUP, <A HREF="runtime-config.html" >Run-time Configuration</A >, <A HREF="client-authentication.html#AUTH-PG-HBA-CONF" >The pg_hba.conf file</A >, <A HREF="auth-methods.html#AEN21569" >Ident Maps</A > </DT ><DT >similar to, <A HREF="functions-matching.html#FUNCTIONS-SQL99-REGEXP" >SIMILAR TO and SQL99 Regular Expressions</A > </DT ><DT >sliced bread </DT ><DD ><DL ><DT >See TOAST</DT ></DL ></DD ><DT >smallint, <A HREF="datatype.html#DATATYPE-NUMERIC" >Numeric Types</A > </DT ><DT >Solaris, <A HREF="postmaster-start.html" >Starting the Database Server</A >, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >some, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >sorting </DT ><DD ><DL ><DT >query results, <A HREF="queries-order.html" >Sorting Rows</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SPI </DT ><DD ><DL ><DT >allocating space, <A HREF="spi-spipalloc.html" >SPI_palloc</A >, <A HREF="spi-spirepalloc.html" >SPI_repalloc</A >, <A HREF="spi-spipfree.html" >SPI_pfree</A >, <A HREF="spi-spifreetuple.html" >SPI_freetuple</A >, <A HREF="spi-spifreetuptable.html" >SPI_freetuptable</A >, <A HREF="spi-spifreeplan.html" >SPI_freeplan</A > </DT ><DD ><DL ></DL ></DD ><DT >connecting, <A HREF="spi-spiconnect.html" >SPI_connect</A >, <A HREF="spi-spiprepare.html" >SPI_prepare</A >, <A HREF="spi-spiexecp.html" >SPI_execp</A >, <A HREF="spi-spisaveplan.html" >SPI_saveplan</A > </DT ><DD ><DL ></DL ></DD ><DT >copying tuple descriptors, <A HREF="spi-spicopytupledesc.html" >SPI_copytupledesc</A > </DT ><DD ><DL ></DL ></DD ><DT >copying tuples, <A HREF="spi-spicopytuple.html" >SPI_copytuple</A >, <A HREF="spi-spicopytupleintoslot.html" >SPI_copytupleintoslot</A > </DT ><DD ><DL ></DL ></DD ><DT >cursors, <A HREF="spi-spicursor-open.html" >SPI_cursor_open</A >, <A HREF="spi-spicursor-find.html" >SPI_cursor_find</A >, <A HREF="spi-spicursor-fetch.html" >SPI_cursor_fetch</A >, <A HREF="spi-spicursor-move.html" >SPI_cursor_move</A >, <A HREF="spi-spicursor-close.html" >SPI_cursor_close</A > </DT ><DD ><DL ></DL ></DD ><DT >decoding tuples, <A HREF="spi-spifnumber.html" >SPI_fnumber</A >, <A HREF="spi-spifname.html" >SPI_fname</A >, <A HREF="spi-spigetvalue.html" >SPI_getvalue</A >, <A HREF="spi-spigetbinval.html" >SPI_getbinval</A >, <A HREF="spi-spigettype.html" >SPI_gettype</A >, <A HREF="spi-spigettypeid.html" >SPI_gettypeid</A >, <A HREF="spi-spigetrelname.html" >SPI_getrelname</A > </DT ><DD ><DL ></DL ></DD ><DT >disconnecting, <A HREF="spi-spifinish.html" >SPI_finish</A > </DT ><DD ><DL ></DL ></DD ><DT >executing, <A HREF="spi-spiexec.html" >SPI_exec</A > </DT ><DD ><DL ></DL ></DD ><DT >modifying tuples, <A HREF="spi-spimodifytuple.html" >SPI_modifytuple</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >SPI_connect, <A HREF="spi-spiconnect.html" >SPI_connect</A > </DT ><DT >SPI_copytuple, <A HREF="spi-spicopytuple.html" >SPI_copytuple</A > </DT ><DT >SPI_copytupledesc, <A HREF="spi-spicopytupledesc.html" >SPI_copytupledesc</A > </DT ><DT >SPI_copytupleintoslot, <A HREF="spi-spicopytupleintoslot.html" >SPI_copytupleintoslot</A > </DT ><DT >SPI_cursor_close, <A HREF="spi-spicursor-close.html" >SPI_cursor_close</A > </DT ><DT >SPI_cursor_fetch, <A HREF="spi-spicursor-fetch.html" >SPI_cursor_fetch</A > </DT ><DT >SPI_cursor_find, <A HREF="spi-spicursor-find.html" >SPI_cursor_find</A > </DT ><DT >SPI_cursor_move, <A HREF="spi-spicursor-move.html" >SPI_cursor_move</A > </DT ><DT >SPI_cursor_open, <A HREF="spi-spicursor-open.html" >SPI_cursor_open</A > </DT ><DT >SPI_exec, <A HREF="spi-spiexec.html" >SPI_exec</A > </DT ><DT >SPI_execp, <A HREF="spi-spiexecp.html" >SPI_execp</A > </DT ><DT >SPI_finish, <A HREF="spi-spifinish.html" >SPI_finish</A > </DT ><DT >SPI_fname, <A HREF="spi-spifname.html" >SPI_fname</A > </DT ><DT >SPI_fnumber, <A HREF="spi-spifnumber.html" >SPI_fnumber</A > </DT ><DT >SPI_freeplan, <A HREF="spi-spifreeplan.html" >SPI_freeplan</A > </DT ><DT >SPI_freetuple, <A HREF="spi-spifreetuple.html" >SPI_freetuple</A > </DT ><DT >SPI_freetuptable, <A HREF="spi-spifreetuptable.html" >SPI_freetuptable</A > </DT ><DT >SPI_getbinval, <A HREF="spi-spigetbinval.html" >SPI_getbinval</A > </DT ><DT >SPI_getrelname, <A HREF="spi-spigetrelname.html" >SPI_getrelname</A > </DT ><DT >SPI_gettype, <A HREF="spi-spigettype.html" >SPI_gettype</A > </DT ><DT >SPI_gettypeid, <A HREF="spi-spigettypeid.html" >SPI_gettypeid</A > </DT ><DT >SPI_getvalue, <A HREF="spi-spigetvalue.html" >SPI_getvalue</A > </DT ><DT >spi_lastoid, <A HREF="pltcl-description.html#AEN36642" >Database Access from PL/Tcl</A > </DT ><DT >SPI_modifytuple, <A HREF="spi-spimodifytuple.html" >SPI_modifytuple</A > </DT ><DT >SPI_palloc, <A HREF="spi-spipalloc.html" >SPI_palloc</A > </DT ><DT >SPI_pfree, <A HREF="spi-spipfree.html" >SPI_pfree</A > </DT ><DT >SPI_prepare, <A HREF="spi-spiprepare.html" >SPI_prepare</A > </DT ><DT >SPI_repalloc, <A HREF="spi-spirepalloc.html" >SPI_repalloc</A > </DT ><DT >SPI_saveplan, <A HREF="spi-spisaveplan.html" >SPI_saveplan</A > </DT ><DT >ssh, <A HREF="ssh-tunnels.html" >Secure TCP/IP Connections with SSH Tunnels</A > </DT ><DT >SSL, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A >, <A HREF="ssl-tcp.html" >Secure TCP/IP Connections with SSL</A >, <A HREF="libpq-connect.html" >Database Connection Functions</A > </DT ><DT >standard deviation, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >statistics, <A HREF="monitoring-stats.html" >Statistics Collector</A > </DT ><DT >strings </DT ><DD ><DL ><DT >See character strings</DT ></DL ></DD ><DT >subqueries, <A HREF="queries-table-expressions.html#QUERIES-SUBQUERIES" >Subqueries</A >, <A HREF="functions-subquery.html" >Subquery Expressions</A > </DT ><DT >subquery, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >substring, <A HREF="functions-string.html" >String Functions and Operators</A >, <A HREF="functions-binarystring.html" >Binary String Functions and Operators</A >, <A HREF="functions-matching.html#FUNCTIONS-SQL99-REGEXP" >SIMILAR TO and SQL99 Regular Expressions</A > </DT ><DT >sum, <A HREF="tutorial-agg.html" >Aggregate Functions</A > </DT ><DT >superuser, <A HREF="tutorial-accessdb.html" >Accessing a Database</A > </DT ><DT >syntax </DT ><DD ><DL ><DT >SQL, <A HREF="sql-syntax.html" >SQL Syntax</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58159" >T</A ></H2 ><DL ><DT >table, <A HREF="tutorial-concepts.html" >Concepts</A > </DT ><DT >Tcl, <A HREF="pgtcl.html" >pgtcl - Tcl Binding Library</A >, <A HREF="pltcl.html" >PL/Tcl - Tcl Procedural Language</A > </DT ><DT >TCP/IP, <A HREF="postmaster-start.html" >Starting the Database Server</A > </DT ><DT >text </DT ><DD ><DL ><DT >See character strings</DT ></DL ></DD ><DT >threads </DT ><DD ><DL ><DT >with libpq, <A HREF="libpq-threading.html" >Threading Behavior</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >tid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ><DT >time </DT ><DD ><DL ><DT >constants, <A HREF="datatype-datetime.html#AEN4001" >Special values</A > </DT ><DD ><DL ></DL ></DD ><DT >current, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-CURRENT" >Current Date/Time</A > </DT ><DD ><DL ></DL ></DD ><DT >data type, <A HREF="datatype-datetime.html#AEN3821" >Times</A > </DT ><DD ><DL ></DL ></DD ><DT >output format, <A HREF="datatype-datetime.html#DATATYPE-DATETIME-OUTPUT" >Date/Time Output</A > </DT ><DD ><DL ><DT >See also Formatting</DT ></DL ></DD ></DL ></DD ><DT >time with time zone </DT ><DD ><DL ><DT >data type, <A HREF="datatype-datetime.html#AEN3821" >Times</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >time without time zone </DT ><DD ><DL ><DT >time, <A HREF="datatype-datetime.html#AEN3821" >Times</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >time zone, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >time zones, <A HREF="datatype-datetime.html#DATATYPE-TIMEZONES" >Time Zones</A >, <A HREF="x11950.html" >Date/Time Key Words</A > </DT ><DT >timeout </DT ><DD ><DL ><DT >authentication, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DD ><DL ></DL ></DD ><DT >deadlock, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timestamp </DT ><DD ><DL ><DT >data type, <A HREF="datatype-datetime.html#AEN3902" >Time stamps</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timestamp with time zone </DT ><DD ><DL ><DT >data type, <A HREF="datatype-datetime.html#AEN3902" >Time stamps</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timestamp without time zone </DT ><DD ><DL ><DT >data type, <A HREF="datatype-datetime.html#AEN3902" >Time stamps</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >timezone </DT ><DD ><DL ><DT >conversion, <A HREF="functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT" >AT TIME ZONE</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >TOAST, <A HREF="largeobjects.html#LO-INTRO" >Introduction</A > </DT ><DD ><DL ><DT >and user-defined types, <A HREF="xtypes.html" >Extending SQL: Types</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >transaction ID </DT ><DD ><DL ><DT >wraparound, <A HREF="routine-vacuuming.html#VACUUM-FOR-WRAPAROUND" >Preventing transaction ID wraparound failures</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >transaction isolation level, <A HREF="runtime-config.html#RUNTIME-CONFIG-GENERAL" >General Operation</A > </DT ><DT >transactions, <A HREF="tutorial-transactions.html" >Transactions</A > </DT ><DT >trigger, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ><DT >triggers </DT ><DD ><DL ><DT >in PL/Tcl, <A HREF="pltcl-description.html#AEN36773" >Trigger Procedures in PL/Tcl</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >Tru64 UNIX, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >true, <A HREF="datatype-boolean.html" >Boolean Type</A > </DT ><DT >types </DT ><DD ><DL ><DT >See data types</DT ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58260" >U</A ></H2 ><DL ><DT >union, <A HREF="queries-union.html" >Combining Queries</A > </DT ><DT >UnixWare, <A HREF="kernel-resources.html#SYSVIPC" >Shared Memory and Semaphores</A >, <A HREF="xfunc-c.html#DFUNC" >Compiling and Linking Dynamically-Loaded Functions</A > </DT ><DT >unqualified names, <A HREF="ddl-schemas.html#DDL-SCHEMAS-PATH" >The Schema Search Path</A > </DT ><DT >UPDATE, <A HREF="tutorial-update.html" >Updates</A > </DT ><DT >upgrading, <A HREF="install-upgrading.html" >If You Are Upgrading</A >, <A HREF="migration.html" >Migration between releases</A > </DT ><DT >user </DT ><DD ><DL ><DT >current, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58283" >V</A ></H2 ><DL ><DT >vacuum, <A HREF="routine-vacuuming.html" >Routine Vacuuming</A > </DT ><DT >variance, <A HREF="functions-aggregate.html" >Aggregate Functions</A > </DT ><DT >version, <A HREF="tutorial-accessdb.html" >Accessing a Database</A >, <A HREF="functions-misc.html" >Miscellaneous Functions</A > </DT ><DT >view, <A HREF="tutorial-views.html" >Views</A > </DT ><DT >views </DT ><DD ><DL ><DT >updating, <A HREF="rules-views.html#RULES-VIEWS-UPDATE" >What about updating a view?</A > </DT ><DD ><DL ></DL ></DD ></DL ></DD ><DT >void, <A HREF="datatype-pseudo.html" >Pseudo-Types</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58305" >W</A ></H2 ><DL ><DT >where, <A HREF="queries-table-expressions.html#QUERIES-WHERE" >The WHERE Clause</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58310" >X</A ></H2 ><DL ><DT >xid, <A HREF="datatype-oid.html" >Object Identifier Types</A > </DT ></DL ><H2 CLASS="INDEXDIV" ><A NAME="AEN58315" >Y</A ></H2 ><DL ><DT >yacc, <A HREF="install-requirements.html" >Requirements</A > </DT ></DL ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="doc-style.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Style Guide</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" > </TD ></TR ></TABLE ></DIV ></BODY ></HTML >