Index

A

aborting

transactions, Inputs , Inputs

adding

columns to a table, Inputs

comments, Inputs

users, Inputs

users to a group, Inputs

aggregate expressions, Aggregate Expressions

aggregate function definition

creating, Inputs

removing, Notes , Inputs

aggregate functions, Aggregate Functions

aliases

column, Table and Column Aliases

table, Table and Column Aliases

ALL, DISTINCT

analyzing

database storage, Inputs

arrays, Array constants, Arrays, Array Types

autocommit

See unchained mode

B

B-tree index, Index Types

base data type

creating, Inputs

base table, Table Expressions

binary format, Binary Format

bit string types, Bit String Types

bit strings, Bit String Constants

boolean type, Boolean Type

bracket expressions, POSIX Regular Expressions

btree

indexes, Notes

C

CASE expressions, Conditional Expressions

chained mode, Description

character types, Character Types

checkpoints

forcing, Description

cidr types, cidr

clauses

FROM, FROM clause

GROUP BY, GROUP BY and HAVING clauses

HAVING, GROUP BY and HAVING clauses

operator, Operator Classes

ORDER BY, Sorting Rows

WHERE, WHERE clause

cleaning

databases, Inputs

closing

cursors, Inputs

clustering

table data, Inputs

ways of, Notes

COALESCE function, Conditional Expressions

collecting

information for optimizer, Description

column alias, Table and Column Aliases

column labels, Column Labels

column references, Column References

columns, Columns

adding, Inputs

renaming, Inputs

updating, Inputs

combining queries, Combining Queries

commands, Lexical Structure

SELECT, Queries

comments, Lexical Structure, Comments

adding, Inputs

committing

transactions, Inputs , Inputs

compatibility, Data Types

concatenation, String Concatenation

conditional expressions, Conditional Expressions

constants, Lexical Structure, Constants

arrays, Array constants

bit string, Bit String Constants

floating point, Floating Point Constants

integer, Integer Constants

operators, Operators and Special Characters

other, Constants of Other Types

string, String Constants

constraint mode

setting, Description

constraint triggers

creating, Inputs

copying

as text, Notes

data, Inputs

in binary, Notes

correlation, Column References

corrupted system indexes

recovering, Inputs

creating

aggregate function definition, Inputs

base data type, Inputs

constraint triggers, Inputs

cursors, Inputs

database, Inputs

functions, Inputs

groups, Inputs

indexes, Inputs

operators, Inputs

rules, Inputs

sequence number generator, Inputs

tables, Inputs

tables using SELECT results, Inputs

triggers, Inputs

views, Inputs

cursors

closing, Inputs

creating, Inputs

moving, Inputs

D

data

clustering, Inputs

copying, Inputs

data types, Data Types

character, Character Types

date/time, Date/Time Types

extending, User-Defined Types

monetary, Monetary Type

numeric, Numeric Types

serial, The Serial Type

database

locations, Description

databases

analyzing storage of, Inputs

cleaning, Inputs

creating, Inputs

dropping, Inputs

date/time input, Date/Time Input

date/time output, Date/Time Output

date/time types, Date/Time Types

default values

restoring run-time parameters to, Inputs

DELETE, Introduction to Indices

delimiters

using, Notes

DISTINCT key word, DISTINCT

DROP INDEX, Introduction to Indices

dropping

aggregate functions, Notes

databases, Inputs

languages, Notes

E

emptying

tables, Inputs

errors

when copying, Notes

EXCEPT, Combining Queries

explicit lock

of a table, Inputs

expressions, Value Expressions

EXTRACT, EXTRACT

F

file formats

binary, Binary Format

text, File Formats

tuples, Tuples

files

loading, Inputs

floating point constants, Floating Point Constants

forcing

checkpoints, Description

formats, Notes

formatting functions, Formatting Functions

FROM clause, FROM clause

function calls, Function Calls

functional index, Functional Indices

functions, Operators and Functions

aggregate, Aggregate Functions

COALESCE, Conditional Expressions

date/time, Date/Time Functions

formatting, Formatting Functions

geometric, Geometric Functions and Operators

large object, Large Object Functions

miscellaneous, Miscellaneous Functions

NULLIF, Conditional Expressions

registering, Inputs

removing, Inputs

trigonometric, Mathematical Functions and Operators

G

geometric functions, Geometric Functions and Operators

geometric types, Geometric Types

boxes, Box

circle, Circle

line segment, Line Segment

path, Path

point, Point

polygon, Polygon

granting

privileges, Inputs

GROUP BY clause, GROUP BY and HAVING clauses

groups

altering, Inputs

creating, Inputs

removing, Inputs

H

hash indexes, Index Types, Notes

HAVING clause, GROUP BY and HAVING clauses

heap pages, Notes

I

identifiers, Lexical Structure, Identifiers and Key Words

implicitly typed constants, Constants

index types, Index Types

indexes, Introduction to Indices, Notes

B-tree, Index Types

btree, Notes

creating, Inputs

functional, Functional Indices

hash, Index Types, Notes

multi-column, Multi-Column Indices

R-tree, Index Types

removing from database, Inputs

rtree, Notes

types of, Index Types, Notes

unique, Unique Indices

inet types, inet

initiating transactions, Inputs

input function, User-Defined Types

inserting

rows, Inputs

integers, Integer Constants

INTERSECT, Combining Queries

J

join types, Joined Tables

joined tables, Joined Tables

K

key words, Lexical Structure

LIMIT, LIMIT and OFFSET

OFFSET, LIMIT and OFFSET

keys, Keys

keywords, Identifiers and Key Words

non-reserved, SQL Key Words

reserved, SQL Key Words

L

languages

creating, Inputs

dropping, Notes

registering, Inputs

removing, Inputs

large object functions, Large Object Functions

lexical precedence, Lexical Precedence

LIKE, Pattern Matching with LIKE

LIMIT, LIMIT and OFFSET

listening

to start, Inputs

to stop, Inputs

literals, Lexical Structure

loading

objects, Inputs

lock modes

access, Description

exclusive, Description

row, Description

share, Description

locking

lock modes, Description

tables, Inputs

logical operators, Logical Operators

M

macaddr types, macaddr

mathematical functions, Mathematical Functions and Operators

miscellaneous functions, Miscellaneous Functions

monetary types, Monetary Type

moving

cursors, Inputs

data, Inputs

multi-column index, Multi-Column Indices

N

names, Identifiers and Key Words

network address types, Network Address Data Types

cidr, cidr

inet, inet

macaddr, macaddr

non-reserved keywords, SQL Key Words

NULLIF function, Conditional Expressions

numeric types, Numeric Types

O

objects

loading, Inputs

OFFSET, LIMIT and OFFSET

operator clauses, Operator Classes

operator precedence, Lexical Precedence

operators, Operators and Special Characters, Operators and Functions

bit string binary, Mathematical Functions and Operators

comparison, Comparison Operators

creating, Inputs

logical, Logical Operators

mathematical, Mathematical Functions and Operators

removing, Inputs

string, String Functions and Operators

ORDER BY, Sorting Rows

output function, User-Defined Types

P

parameters

setting, Inputs

password

changing for a user, Inputs

pattern matching, Pattern Matching

positional parameters, Positional Parameters

precedence

lexical, Lexical Precedence

operator, Lexical Precedence

privileges

changing user attributes, Inputs

granting, Inputs

revoking, Inputs

Q

queries, Queries

combining, Combining Queries

quoted identifiers, Lexical Structure

R

R-tree index, Index Types

recovering

corrupted system indexes, Inputs

registering

functions, Inputs

languages, Inputs

regular expressions, POSIX Regular Expressions

removing

aggregate function definition, Inputs

functions, Inputs

groups, Inputs

indexes from database, Inputs

operators, Inputs

rows, Inputs

rules, Inputs

sequences, Inputs

tables, Inputs

triggers, Inputs

types, Inputs

user-defined language, Inputs

users, Inputs

users from a group, Inputs

views, Inputs

renaming

columns in a table, Inputs

tables, Inputs

reserved keywords, SQL Key Words

retrieving

rows, Inputs , Inputs

revoking

privileges, Inputs

rolling back

transactions, Inputs

rows

inserting, Inputs

removing, Inputs

retrieving, Inputs

selecting, Inputs

rtree

indexes, Notes

rules

creating, Inputs

removing, Inputs

semantics, Description

run-time parameters

restoring to default values, Inputs

setting, Inputs

showing, Inputs

S

scalar expressions, Value Expressions

SELECT, Queries

select list, Queries

select lists, Select Lists

selecting

rows, Inputs

sequence number generator

creating, Inputs

sequences

removing, Inputs

serial types, The Serial Type

setting

constraint mode, Description

run-time parameters, Inputs

transaction characteristics, Description

showing

run-time parameters, Inputs

sort specification, Queries

sorting, Sorting Rows

special characters, Operators and Special Characters

starting

listen, Inputs

statement execution plan

viewing, Inputs

stopping

listen, Inputs

storage

reclaiming, Description

string concatenation, String Concatenation

string functions, String Functions and Operators

strings, String Constants

subqueries, Subqueries

T

table

creating using SELECT results, Inputs

table alias, Table and Column Aliases

table expressions, Queries, Table Expressions

tables

creating, Inputs

emptying, Inputs

joined, Joined Tables

locking, Inputs

modifying properties, Inputs

removing, Inputs

renaming, Inputs

text format, File Formats

time zones, Time Zones

TOAST

and user-defined types, Types and TOAST Tables

tokens, Lexical Structure, SQL Key Words

transaction

rolling back, Inputs

transaction characteristics

setting, Description

transactions

committing, Inputs , Inputs

initiating, Inputs

trigger

removing, Inputs

triggers

creating, Inputs

trigonometric functions, Mathematical Functions and Operators

tuples, Tuples

type conversion, Type Conversion

geometric, Geometric Functions and Operators

types

bit string, Bit String Types

network address, Network Address Data Types

removing, Inputs

U

UNION, Combining Queries

unique index, Unique Indices

UPDATE, Introduction to Indices

updating

columns, Inputs

user passwords

changing, Inputs

setting expiry date, Inputs

user privileges

changing, Inputs

revoking, Inputs

users

adding, Inputs

adding to groups, Inputs

removing, Inputs

removing from groups, Inputs

V

VACUUM, Notes

VACUUM ANALYZE, Introduction to Indices

value expressions, Value Expressions

viewing

statement execution plan, Inputs

views

creating, Inputs

removing, Inputs

W

WHERE clause, WHERE clause

Write-Ahead Logging, Description