Red Hat Database: SQL Guide and Reference
Prev 

Index

A

aborting
transactions, ABORT , ROLLBACK
access privileges
granting, GRANT
adding
columns to a table, ALTER TABLE
comments, COMMENT
users, CREATE USER
users to a group, ALTER GROUP
aggregate expressions, Aggregate Expressions
aggregate function definition
creating, CREATE AGGREGATE
removing, Notes , DROP AGGREGATE
aggregate functions, Aggregate Functions
aliases
column, Table and Column Aliases
table, Table and Column Aliases
ALL, DISTINCT
analyzing
database storage, VACUUM
and, operator, Logical Operators
arrays, Array Constants, Arrays, Array Types
autocommit
See unchained mode

B

B-tree
indexes, Notes
B-tree index, Index Types
base data type
creating, CREATE TYPE
base table, Table Expressions
bigint, Numeric Types
bigserial data type, The Serial Type
binary format, Binary Format
binary strings
concatenation, Binary String Functions and Operators
length, Binary String Functions and Operators
bit string constants, Bit String Constants
bit string types, Bit String Types
boolean data type, Boolean Type
bracket expressions, POSIX Regular Expressions

C

CASE expressions, Conditional Expressions
case sensitivity
SQL commands, Identifiers and Key Words
chained mode, Description
character strings
concatenation, String Functions and Operators
constants, String Constants
data types, Character Types
length, String Functions and Operators
character types, Character Types
checkpoints
forcing, CHECKPOINT
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, VACUUM
closing
cursors, CLOSE
clustering
table data, CLUSTER
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
adding, ALTER TABLE
renaming, ALTER TABLE
system columns, Columns
updating, UPDATE
col_description, Miscellaneous Functions
combining queries, Combining Queries
commands, Lexical Structure
SELECT, Queries
comments, Lexical Structure
adding, COMMENT
in SQL, Comments
committing
transactions, COMMIT , END
compatibility, Data Types
concatenation, String Concatenation Operator Type Resolution
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
string, String Constants
constraint mode
setting, SET CONSTRAINTS
constraint triggers
creating, CREATE CONSTRAINT TRIGGER
copying
as text, Notes
data, COPY
in binary, Notes
correlation, Column References
corrupted system indexes
recovering, REINDEX
creating
aggregate function definition, CREATE AGGREGATE
base data type, CREATE TYPE
constraint triggers, CREATE CONSTRAINT TRIGGER
cursors, DECLARE
database, CREATE DATABASE
groups, CREATE GROUP
indexes, CREATE INDEX
operators, CREATE OPERATOR
rules, CREATE RULE
sequence number generator, CREATE SEQUENCE
tables, CREATE TABLE
tables using SELECT results, CREATE TABLE AS
triggers, CREATE TRIGGER
views, CREATE VIEW
currval, Sequence-Manipulation Functions
cursors
closing, CLOSE
creating, DECLARE
moving, MOVE

D

data
clustering, CLUSTER
copying, COPY
data types, Data Types
character, Character Types
constants, Constants of Other Types
date/time, Date/Time Types
extending, User-Defined Types
monetary, Monetary Type
numeric, Numeric Types
serial, The Serial Type
type casts, Type Casts
database
collecting statistics, ANALYZE
locations, Description
databases
analyzing storage of, VACUUM
cleaning, VACUUM
creating, CREATE DATABASE
dropping, DROP DATABASE
date
current, Current Date/Time
output format, Date/Time Output
See also Formatting
date constants, Special Values
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, RESET
DELETE
running on indexes, Introduction to Indexes
delimiters
using, Notes
DISTINCT key word, DISTINCT
double precision, Numeric Types
DROP INDEX, Introduction to Indexes
dropping
aggregate functions, Notes
databases, DROP DATABASE
languages, Notes

E

emptying
tables, TRUNCATE
errors
when copying, Notes
EXCEPT, Combining Queries
explicit lock
of a table, LOCK
expressions, Value Expressions
EXTRACT, EXTRACT

F

file formats
binary, Binary Format
text, File Formats
tuples, Tuples
files
loading, LOAD
floating point, Numeric Types
floating point constants, Floating Point Constants
forcing
checkpoints, CHECKPOINT
formats, Notes
formatting functions, Formatting Functions
FROM clause, FROM clause
function calls, Function Calls
functional index, Functional Indexes
functions, Operators and Functions
aggregate, Aggregate Functions
COALESCE, Conditional Expressions
creating, CREATE FUNCTION
date/time, Date/Time Functions and Operators
formatting, Formatting Functions
geometric, Geometric Functions and Operators
large object, Large Object Functions
miscellaneous, Miscellaneous Functions
NULLIF, Conditional Expressions
removing, DROP FUNCTION
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
GROUP BY clause, GROUP BY and HAVING clauses
groups
altering, ALTER GROUP
creating, CREATE GROUP
removing, DROP GROUP

H

hash indexes, Index Types, Notes
has_table_privilege, Miscellaneous Functions
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 Indexes, Notes
B-tree, Index Types, Notes
creating, CREATE INDEX
functional, Functional Indexes
hash, Index Types, Notes
multi-column, Multi-Column Indexes
partial, Partial Indexes
R-tree, Index Types, Notes
removing from database, DROP INDEX
types of, Index Types, Notes
unique, Unique Indexes
inet types, inet
initiating transactions, BEGIN
input function, User-Defined Types
inserting
rows, INSERT
integer, Numeric Types
integers, Integer Constants
INTERSECT, Combining Queries
interval, interval [ ( p ) ]

J

join types, Joined Tables
joined tables, Joined Tables

K

key words, Lexical Structure, SQL Key Words
LIMIT, LIMIT and OFFSET
OFFSET, LIMIT and OFFSET
syntax, Identifiers and Key Words
keys, Keys

L

languages
creating, CREATE LANGUAGE
dropping, Notes
registering, CREATE LANGUAGE
removing, DROP LANGUAGE
large object functions, Large Object Functions
lexical precedence, Lexical Precedence
LIKE, Pattern Matching with LIKE
LIMIT, LIMIT and OFFSET
listening
to start, LISTEN
to stop, UNLISTEN
literals, Lexical Structure
loading
objects, LOAD
lock modes
access, Description
exclusive, Description
row, Description
share, Description
locking
lock modes, Description
tables, LOCK
logical operators, Logical Operators

M

macaddr types, macaddr
mathematical functions, Mathematical Functions and Operators
miscellaneous functions, Miscellaneous Functions
monetary types, Monetary Type
moving
cursors, MOVE
data, COPY
multi-column index, Multi-Column Indexes

N

names, Identifiers and Key Words
network address types, Network Address Data Types
cidr, cidr
inet, inet
macaddr, macaddr
nextval, Sequence-Manipulation Functions
non-reserved keywords, SQL Key Words
not, operator, Logical Operators
notify condition
signals frontends and backends, NOTIFY
NULLIF function, Conditional Expressions
numeric (data type), Numeric Types
numeric types, Numeric Types

O

objects
loading, LOAD
obj_description, Miscellaneous Functions
OFFSET, LIMIT and OFFSET
operator clauses, Operator Classes
operator precedence, Lexical Precedence
operators, Operators and Functions
bit string binary, Mathematical Functions and Operators
comparison, Comparison Operators
creating, CREATE OPERATOR
logical, Logical Operators
mathematical, Mathematical Functions and Operators
removing, DROP OPERATOR
string, String Functions and Operators
syntax, Operators
or, operator, Logical Operators
ORDER BY, Sorting Rows
output function, User-Defined Types

P

parameters
setting, SET
password
changing for a user, ALTER USER
pattern matching, Pattern Matching
pg_get_indexdef, Miscellaneous Functions
pg_get_ruledef, Miscellaneous Functions
pg_get_userbyid, Miscellaneous Functions
pg_get_viewdef, Miscellaneous Functions
positional parameters, Positional Parameters
precedence
lexical, Lexical Precedence
operator, Lexical Precedence
privileges
changing user attributes, ALTER USER
revoking, REVOKE

Q

queries, Queries
combining, Combining Queries
quoted identifiers, Lexical Structure
quotes
and identifiers, Identifiers and Key Words

R

R-tree
indexes, Notes
R-tree index, Index Types
real, Numeric Types
recovering
corrupted system indexes, REINDEX
registering
languages, CREATE LANGUAGE
regular expressions, POSIX Regular Expressions
removing
aggregate function definition, DROP AGGREGATE
functions, DROP FUNCTION
groups, DROP GROUP
indexes from database, DROP INDEX
operators, DROP OPERATOR
rows, DELETE
rules, DROP RULE
sequences, DROP SEQUENCE
tables, DROP TABLE
triggers, DROP TRIGGER
types, DROP TYPE
user-defined language, DROP LANGUAGE
users, DROP USER
users from a group, ALTER GROUP
views, DROP VIEW
renaming
columns in a table, ALTER TABLE
tables, ALTER TABLE
reserved keywords, SQL Key Words
retrieving
rows, FETCH , SELECT
revoking
privileges, REVOKE
rolling back
transactions, ROLLBACK
rows
inserting, INSERT
removing, DELETE
retrieving, FETCH
selecting, SELECT
rules
creating, CREATE RULE
removing, DROP RULE
semantics, Description
run-time parameters
restoring to default values, RESET
setting, SET
showing, SHOW

S

scalar expressions, Value Expressions
SELECT, Queries
select list, Queries
select lists, Select Lists
selecting
rows, SELECT
sequence number generator
creating, CREATE SEQUENCE
sequences, Sequence-Manipulation Functions
and serial type, The Serial Type
removing, DROP SEQUENCE
serial data type, The Serial Type
serial types, The Serial Type
serial4 data type, The Serial Type
serial8 data type, The Serial Type
session authorization
setting, SET SESSION AUTHORIZATION
setting
constraint mode, SET CONSTRAINTS
run-time parameters, SET
transaction characteristics, SET TRANSACTION
setval, Sequence-Manipulation Functions
showing
run-time parameters, SHOW
smallint, Numeric Types
sort specification, Queries
sorting, Sorting Rows
special characters, Special Characters
starting
listen, LISTEN
statement execution plan
viewing, EXPLAIN
stopping
listen, UNLISTEN
storage
reclaiming, Description
string concatenation, String Concatenation Operator Type Resolution
string functions, String Functions and Operators
strings, String Constants
subqueries, Subqueries
substring, String Functions and Operators, Binary String Functions and Operators
syntax
SQL, SQL Syntax

T

table
creating using SELECT results, CREATE TABLE AS
table alias, Table and Column Aliases
table expressions, Queries, Table Expressions
tables
creating, CREATE TABLE
emptying, TRUNCATE
joined, Joined Tables
locking, LOCK
modifying properties, ALTER TABLE
removing, DROP TABLE
renaming, ALTER TABLE
text format, File Formats
time
current, Current Date/Time
data type, time [ ( p ) ] [ without time zone ], time [ ( p ) ] with time zone
output format, Date/Time Output
See also Formatting
time constants, Special Values
time with time zone
data type, time [ ( p ) ] with time zone
time without time zone
time, time [ ( p ) ] [ without time zone ]
time zones, Time Zones
timestamp
data type, timestamp [ (p) ] with time zone
timestamp without time zone
data type, timestamp [ (p) ] without time zone
TOAST
and user-defined types, Types and TOAST Tables
tokens, Lexical Structure, SQL Key Words
transaction
rolling back, ROLLBACK
transaction characteristics
setting, SET TRANSACTION
transactions
aborting, ABORT
committing, COMMIT , END
initiating, BEGIN
trigger
removing, DROP TRIGGER
triggers
creating, CREATE TRIGGER
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, DROP TYPE

U

UNION, Combining Queries
unique index, Unique Indexes
UPDATE
running on indexes, Introduction to Indexes
updating
columns, UPDATE
user passwords
changing, ALTER USER
setting expiry date, ALTER USER
user privileges
changing, ALTER USER
revoking, REVOKE
users
adding, CREATE USER
adding to groups, ALTER GROUP
removing, DROP USER
removing from groups, ALTER GROUP

V

VACUUM ANALYZE, Introduction to Indexes
value expressions, Value Expressions
viewing
statement execution plan, EXPLAIN
views
creating, CREATE VIEW
removing, DROP VIEW

W

WHERE clause, WHERE clause
Write-Ahead Logging, CHECKPOINT
PrevHome 
SQL Key Words