PostgreSQL: Documentation: 7.3: Index

PostgreSQL 7.3.21 Documentation
Prev

Symbols

$libdir, Dynamic Loading

A

aggregate, Aggregate Functions

aggregate functions, Aggregate Expressions

extending, Extending SQL: Aggregates

alias

see label
for table name in query, Joins Between Tables

all, Subquery Expressions

and

operator, Logical Operators

any, Pseudo-Types, Subquery Expressions

anyarray, Pseudo-Types

arrays, Arrays, Extending SQL: Types

constants, Array constants

Australian time zones, General Operation

auto-increment

see serial

autocommit, General Operation

average, Aggregate Functions

function, Aggregate Functions

B

B-tree

see indexes

backslash_quote configuration parameter, General Operation

backup, Backup and Restore

between, Comparison Operators

bigint, Numeric Types

bigserial, The Serial Types

binary strings

concatenation, Binary String Functions and Operators
length, Binary String Functions and Operators

bison, Requirements

bit strings

constants, Bit-String Constants
data type, Bit String Types

BLOB

see large object

Boolean

data type, Boolean Type

operators

see operators, logical

box (data type), Box

BSD/OS, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

bytea

in libpq, Escaping Binary Strings for Inclusion in SQL Commands

C

case, Conditional Expressions

case sensitivity

SQL commands, Identifiers and Key Words

catalogs, About the PostgreSQL System Catalogs

character set encoding, General Operation

character strings

concatenation, String Functions and Operators
constants, String Constants
data types, Character Types
length, String Functions and Operators

cid, Object Identifier Types

cidr, cidr

circle, Circle

client authentication, Client Authentication

cluster, Concepts

column, Concepts

columns

system columns, System Columns

col_description, Miscellaneous Functions

comments

in SQL, Comments

comparison

operators, Comparison Operators

concurrency, Concurrency Control

conditionals, Conditional Expressions

configuration

server, Run-time Configuration

configure, Installation Procedure

connection loss, pg_on_connection_loss

constants, Constants

COPY, Populating a Table With Rows

with libpq, Functions Associated with the COPY Command

count, Aggregate Functions

CREATE TABLE, Creating a New Table

createdb, Creating a Database

crypt, Password authentication

cstring, Pseudo-Types

currval, Sequence-Manipulation Functions

D

data area

see database cluster

data types, Data Types, The PostgreSQL Type System

constants, Constants of Other Types
extending, Extending SQL: Types
numeric, Numeric Types
type casts, Type Casts

database, Managing Databases

creating, Creating a Database

database cluster, Creating a Database Cluster

date

constants, Special values

current, Current Date/Time

data type, Dates

output format, Date/Time Output

see also Formatting

date style, General Operation

deadlock

timeout, General Operation

decimal

see numeric

DELETE, Deletions

Digital UNIX

see Tru64 UNIX

dirty read, Transaction Isolation

disk space, Recovering disk space

disk usage, Determining Disk Usage

DISTINCT, Querying a Table, DISTINCT

double precision, Numeric Types

DROP TABLE, Creating a New Table

duplicate, Querying a Table

dynamic loading, General Operation

dynamic_library_path, General Operation, Dynamic Loading

E

elog, Database Access from PL/Tcl

PL/Perl, Database Access from PL/Perl

embedded SQL

in C, ECPG - Embedded SQL in C

environment variables, Environment Variables

error message, Database Connection Functions

escaping strings, Escaping Strings for Inclusion in SQL Commands

except, Combining Queries

exists, Subquery Expressions

extending SQL, Extending SQL: An Overview

types, The PostgreSQL Type System

F

false, Boolean Type

FETCH

embedded SQL, Porting From Other RDBMS Packages

files, Files

flex, Requirements

float4

see real

float8

see double precision

floating point, Numeric Types

foreign key, Foreign Keys

formatting, Data Type Formatting Functions

FreeBSD, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

fsync, General Operation

function, Extending SQL: Functions, Table Functions

internal, Internal Functions
SQL, Query Language (SQL) Functions

functions, Functions and Operators

G

genetic query optimization, Planner and Optimizer Tuning

GEQO

see genetic query optimization

get_bit, Binary String Functions and Operators

get_byte, Binary String Functions and Operators

group, The GROUP BY and HAVING Clauses

GROUP BY, Aggregate Functions

H

hash

see indexes

has_database_privilege, Miscellaneous Functions

has_function_privilege, Miscellaneous Functions

has_language_privilege, Miscellaneous Functions

has_schema_privilege, Miscellaneous Functions

has_table_privilege, Miscellaneous Functions

HAVING, Aggregate Functions

hierarchical database, Concepts

HP-UX, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

I

ident, Ident-based authentication

identifiers, Identifiers and Key Words

in, Subquery Expressions

index scan, Planner and Optimizer Tuning

indexes, Indexes

B-tree, Index Types
hash, Index Types
multicolumn, Multicolumn Indexes
on functions, Functional Indexes
partial, Partial Indexes
R-tree, Index Types
unique, Unique Indexes

inet (data type), inet

inheritance, Inheritance, General Operation

initlocation, Alternative Locations

input function, Extending SQL: Types

INSERT, Populating a Table With Rows

installation, Installation Instructions

on Windows, Requirements, Installation on Windows

int2

see smallint

int4

see integer

int8

see bigint

integer, Numeric Types

internal, Pseudo-Types

intersection, Combining Queries

interval, Intervals

IRIX, Compiling and Linking Dynamically-Loaded Functions

IS NULL, General Operation

isolation levels, Transaction Isolation

read committed, Read Committed Isolation Level
read serializable, Serializable Isolation Level

J

join, Joins Between Tables

outer, Joins Between Tables
self, Joins Between Tables

joins, Joined Tables

cross, Joined Tables
left, Joined Tables
natural, Joined Tables
outer, Joined Tables

K

Kerberos, Kerberos authentication

key words

list of, SQL Key Words
syntax, Identifiers and Key Words

L

label

column, Column Labels
table, Table and Column Aliases

language_handler, Pseudo-Types

large object, Large Objects

LC_COLLATE, Creating a Database Cluster

ldconfig, Shared Libraries

length

binary strings

see binary strings, length

character strings

see character strings, length

libperl, Requirements

libpgtcl, pgtcl - Tcl Binding Library

libpq, libpq - C Library

libpq-fe.h, Database Connection Functions

libpq-int.h, Database Connection Functions, Building Libpq Programs

libpython, Requirements

like, LIKE

limit, LIMIT and OFFSET

line, Line Segment

Linux, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

locale, Creating a Database Cluster, Locale Support

locking, Explicit Locking

log files, Log File Maintenance

M

MAC address

see macaddr

macaddr (data type), macaddr

MacOS X, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

make, Requirements

MANPATH, Environment Variables

see also man pages

max, Aggregate Functions

MD5, Password authentication

min, Aggregate Functions

multibyte, Multibyte Support

N

names

qualified, Creating a Schema
unqualified, The Schema Search Path

namespaces, Schemas, General Operation

NetBSD, Starting the Database Server, Shared Memory and Semaphores, Compiling and Linking Dynamically-Loaded Functions

network

addresses, Network Address Data Types

nextval, Sequence-Manipulation Functions

nonblocking connection, Database Connection Functions, Asynchronous Query Processing

nonrepeatable read, Transaction Isolation

not

operator, Logical Operators

not in, Subquery Expressions

notice processor, libpq Control Functions

NOTIFY, Asynchronous Notification,