- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 454 pages
ISBN 9781906966041
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

Index

$

  • $
  • *

  • *
  • :

  • ::
  • a

  • abs
  • acos
  • age
  • aggregate function, built-in
  • aggregate function, invocation
  • alias, in the FROM clause
  • alias, in the select list
  • ALL, ALL
  • AND (operator)
  • ANY, ANY, ANY
  • any
  • anyarray
  • anyelement
  • anyenum
  • anynonarray
  • arbitrary precision numbers
  • area
  • ARRAY
  • array
  • array, accessing
  • array, constant
  • array, constructor
  • array, declaration
  • ARRAY, determination of result type
  • array, I/O
  • array, modifying
  • array, searching
  • array_agg
  • array_append
  • array_cat
  • array_dims
  • array_fill
  • array_length
  • array_lower
  • array_ndims
  • array_prepend
  • array_to_string
  • array_upper
  • ascii
  • asin
  • AT TIME ZONE
  • atan
  • atan2
  • auto-increment
  • autocommit, bulk-loading data
  • average
  • b

  • B-tree
  • backslash escapes
  • backup
  • BETWEEN
  • BETWEEN SYMMETRIC
  • bigint, bigint
  • bigserial
  • binary data
  • binary data, functions
  • binary string, concatenation
  • binary string, length
  • bit string, constant
  • bit string, data type
  • bit strings, functions
  • bit_and
  • bit_length
  • bit_or
  • bitmap scan
  • bool_and
  • bool_or
  • Boolean, data type
  • Boolean, operators
  • box (data type)
  • btrim
  • bytea
  • c

  • CASCADE, foreign key action
  • CASCADE, with DROP
  • CASE
  • case sensitivity, of SQL commands
  • CASE, determination of result type
  • cbrt
  • ceiling
  • center
  • char
  • char_length
  • character
  • character string, concatenation
  • character string, constant
  • character string, data types
  • character string, length
  • character varying
  • check constraint
  • chr
  • cid
  • cidr
  • circle
  • clock_timestamp
  • cmax
  • cmin
  • COALESCE
  • col_description
  • column
  • column data type, changing
  • column reference
  • column, adding
  • column, removing
  • column, renaming
  • column, system column
  • comment, about database objects
  • comment, in SQL
  • common table expression
  • comparison, operators
  • comparison, row-wise
  • comparison, subquery result row
  • composite type
  • composite type, constant
  • composite type, constructor
  • concurrency
  • conditional expression
  • configuration, of the server, functions
  • conjunction
  • constant
  • constraint
  • constraint exclusion
  • constraint, adding
  • constraint, check
  • constraint, exclusion
  • constraint, foreign key
  • constraint, name
  • constraint, NOT NULL
  • constraint, primary key
  • constraint, removing
  • constraint, unique
  • convert
  • convert_from
  • convert_to
  • correlation
  • cos
  • cot
  • covariance, population
  • covariance, sample
  • cross join
  • cstring
  • ctid
  • cume_dist
  • current_catalog
  • current_database
  • current_date
  • current_schema
  • current_time
  • current_timestamp
  • current_user
  • currval
  • d

  • data type
  • data type, category
  • data type, constant
  • data type, conversion
  • data type, enumerated (enum)
  • data type, numeric
  • data type, type cast
  • date, date
  • date, constants
  • date, current
  • date, output format
  • date_part, date_part
  • date_trunc, date_trunc
  • deadlock
  • decimal
  • decode
  • default value
  • default value, changing
  • degrees
  • delay
  • DELETE
  • deleting
  • dense_rank
  • diameter
  • dirty read
  • disjunction
  • DISTINCT
  • div
  • document, text search
  • dollar quoting
  • double precision
  • DTD
  • duplicates
  • e

  • encode
  • enumerated types
  • error codes, list of
  • escape string syntax
  • every
  • EXCEPT
  • exclusion constraint
  • EXISTS
  • exp
  • EXPLAIN
  • expression, order of evaluation
  • expression, syntax
  • extract, extract
  • f

  • false
  • field selection
  • first_value
  • float4
  • float8
  • floating point
  • floor
  • foreign key
  • format_type
  • formatting
  • full text search
  • full text search, data types
  • full text search, functions and operators
  • function
  • function, in the FROM clause
  • function, invocation
  • function, mixed notation
  • function, named notation
  • function, positional notation
  • function, type resolution in an invocation
  • g

  • generate_series
  • generate_subscripts
  • get_bit
  • get_byte
  • GIN
  • GiST
  • GREATEST
  • GREATEST, determination of result type
  • GROUP BY
  • grouping
  • GUID
  • h

  • has_any_column_privilege
  • has_column_privilege
  • has_database_privilege
  • has_foreign_data_wrapper_privilege
  • has_function_privilege
  • has_language_privilege
  • has_schema_privilege
  • has_sequence_privilege
  • has_server_privilege
  • has_table_privilege
  • has_tablespace_privilege
  • hash
  • HAVING
  • height
  • history, of PostgreSQL
  • i

  • identifier, length
  • identifier, syntax of
  • IFNULL
  • IN, IN
  • index
  • Index
  • index, and ORDER BY
  • index, B-tree
  • index, combining multiple indexes
  • index, examining usage
  • index, GIN
  • index, GIN, text search
  • index, GiST
  • index, GiST, text search
  • index, hash
  • index, locks
  • index, multicolumn
  • index, on expressions
  • index, partial
  • index, unique
  • inet (data type)
  • inet_client_addr
  • inet_client_port
  • inet_server_addr
  • inet_server_port
  • inheritance
  • initcap
  • INSERT
  • inserting
  • int2
  • int4
  • int8
  • integer, integer
  • internal
  • INTERSECT
  • interval, interval
  • interval, output format
  • IS DISTINCT FROM, IS DISTINCT FROM
  • IS DOCUMENT
  • IS FALSE
  • IS NOT DISTINCT FROM, IS NOT DISTINCT FROM
  • IS NOT FALSE
  • IS NOT NULL
  • IS NOT TRUE
  • IS NOT UNKNOWN
  • IS NULL
  • IS TRUE
  • IS UNKNOWN
  • isclosed
  • isfinite
  • ISNULL
  • isopen
  • j

  • join
  • join, controlling the order
  • join, cross
  • join, left
  • join, natural
  • join, outer
  • join, right
  • justify_days
  • justify_hours
  • justify_interval
  • k

  • key word, list of
  • key word, syntax of
  • l

  • label
  • lag
  • language_handler
  • last_value
  • lastval
  • lead
  • LEAST
  • LEAST, determination of result type
  • left join
  • length
  • length(tsvector)
  • length, of a binary string
  • length, of a character string
  • LIKE
  • LIMIT
  • line segment
  • linear regression
  • ln
  • localtime
  • localtimestamp
  • LOCK
  • lock
  • lock, advisory
  • log
  • lower
  • lpad
  • lseg
  • ltrim
  • m

  • MAC address
  • macaddr (data type)
  • md5
  • mod
  • MVCC
  • n

  • name, qualified
  • name, syntax of
  • name, unqualified
  • NaN
  • natural join
  • negation
  • network, data types
  • nextval
  • non-durable
  • nonrepeatable read
  • NOT (operator)
  • not a number, double precision
  • not a number, numeric (data type)
  • NOT IN, NOT IN
  • not-null constraint
  • notation, functions
  • NOTNULL
  • now
  • npoints
  • nth_value
  • ntile
  • null value, comparing
  • null value, default value
  • null value, in DISTINCT
  • null value, with check constraints
  • null value, with unique constraints
  • NULLIF
  • number, constant
  • numeric
  • numeric (data type)
  • numnode
  • NVL
  • o

  • obj_description
  • object identifier, data type
  • octet_length
  • OFFSET
  • oid
  • OID, column
  • ONLY
  • opaque
  • operator
  • operator class
  • operator family
  • operator, invocation
  • operator, logical
  • operator, precedence
  • operator, syntax
  • operator, type resolution in an invocation
  • OR (operator)
  • ORDER BY
  • outer join
  • OVER clause
  • overlay
  • p

  • parameter, syntax
  • parenthesis
  • partitioning
  • path (data type)
  • pattern matching
  • pclose
  • percent_rank
  • performance
  • permission
  • pg_advisory_lock
  • pg_advisory_lock_shared
  • pg_advisory_unlock
  • pg_advisory_unlock_all
  • pg_advisory_unlock_shared
  • pg_cancel_backend
  • pg_client_encoding
  • pg_column_size
  • pg_conf_load_time
  • pg_conversion_is_visible
  • pg_current_xlog_insert_location
  • pg_current_xlog_location
  • pg_database_size
  • pg_function_is_visible
  • pg_get_constraintdef
  • pg_get_expr
  • pg_get_function_arguments
  • pg_get_function_identity_arguments
  • pg_get_function_result
  • pg_get_functiondef
  • pg_get_indexdef
  • pg_get_keywords
  • pg_get_ruledef
  • pg_get_serial_sequence
  • pg_get_triggerdef
  • pg_get_userbyid
  • pg_get_viewdef
  • pg_has_role
  • pg_indexes_size
  • pg_is_in_recovery
  • pg_is_other_temp_schema
  • pg_last_xlog_receive_location
  • pg_last_xlog_replay_location
  • pg_listening_channels
  • pg_ls_dir
  • pg_my_temp_schema
  • pg_opclass_is_visible
  • pg_operator_is_visible
  • pg_postmaster_start_time
  • pg_read_file
  • pg_relation_filenode
  • pg_relation_filepath
  • pg_relation_size
  • pg_reload_conf
  • pg_rotate_logfile
  • pg_size_pretty
  • pg_sleep
  • pg_start_backup
  • pg_stat_file
  • pg_statistic
  • pg_stats
  • pg_stop_backup
  • pg_switch_xlog
  • pg_table_is_visible
  • pg_table_size
  • pg_tablespace_databases
  • pg_tablespace_size
  • pg_terminate_backend
  • pg_total_relation_size
  • pg_try_advisory_lock
  • pg_try_advisory_lock_shared
  • pg_ts_config_is_visible
  • pg_ts_dict_is_visible
  • pg_ts_parser_is_visible
  • pg_ts_template_is_visible
  • pg_type_is_visible
  • pg_typeof
  • pg_xlogfile_name
  • pg_xlogfile_name_offset
  • phantom read
  • pi
  • plainto_tsquery
  • point
  • polygon
  • popen
  • position
  • POSTGRES
  • Postgres95
  • power
  • predicate locking
  • primary key
  • privilege
  • privilege, for schemas
  • privilege, querying
  • q

  • qualified name
  • query
  • query plan
  • querytree
  • quotation marks, and identifiers
  • quotation marks, escaping
  • quote_ident
  • quote_literal
  • quote_nullable
  • r

  • radians
  • radius
  • random
  • rank
  • real
  • record
  • rectangle
  • referential integrity
  • regclass
  • regconfig
  • regdictionary
  • regexp_matches
  • regexp_replace
  • regexp_split_to_array
  • regexp_split_to_table
  • regoper
  • regoperator
  • regproc
  • regprocedure
  • regression intercept
  • regression slope
  • regtype
  • regular expression, regular expression
  • repeat
  • replace
  • RESTRICT, foreign key action
  • RESTRICT, with DROP
  • right join
  • round
  • ROW
  • row
  • row type
  • row type, constructor
  • row-wise comparison
  • row_number
  • rpad
  • rtrim
  • s

  • scalar
  • schema
  • schema, creating
  • schema, current, schema, current
  • schema, public
  • schema, removing
  • search path
  • search path, current
  • search_path
  • SELECT
  • SELECT, select list
  • sequence
  • sequence, and serial type
  • serial
  • serial4
  • serial8
  • serializability
  • SET
  • set difference
  • set intersection
  • set operation
  • set returning functions, functions
  • set union
  • set_bit
  • set_byte
  • setseed
  • setval
  • setweight
  • shobj_description
  • SHOW
  • sign
  • signal, backend processes
  • SIMILAR TO
  • sin
  • sleep
  • smallint
  • SOME, SOME, SOME
  • sorting
  • split_part
  • SQL/CLI
  • SQL/Foundation
  • SQL/Framework
  • SQL/JRT
  • SQL/MED
  • SQL/OLB
  • SQL/PSM
  • SQL/Schemata
  • SQL/XML
  • sqrt
  • standard deviation
  • standard deviation, population
  • standard deviation, sample
  • statement_timestamp
  • statistics
  • statistics, of the planner
  • string
  • string_agg
  • string_to_array
  • strip
  • strpos
  • subquery, subquery, subquery
  • subscript
  • substr
  • substring, substring, substring, substring
  • suppress_redundant_updates_trigger
  • syntax, SQL
  • system catalog, schema
  • t

  • table
  • table expression
  • table function
  • table, creating
  • table, inheritance
  • table, modifying
  • table, partitioning
  • table, removing
  • table, renaming
  • tableoid
  • tan
  • text
  • text search
  • text search, data types
  • text search, functions and operators
  • text search, indexes
  • tid
  • time, time
  • time span
  • time with time zone, time with time zone
  • time without time zone, time without time zone
  • time zone
  • time zone, conversion
  • time zone, input abbreviations
  • time, constants
  • time, current
  • time, output format
  • timeofday
  • timestamp, timestamp
  • timestamp with time zone, timestamp with time zone
  • timestamp without time zone, timestamp without time zone
  • to_ascii
  • to_char
  • to_date
  • to_hex
  • to_number
  • to_timestamp
  • to_tsquery
  • to_tsvector
  • token
  • transaction isolation
  • transaction isolation level
  • transaction isolation level, read committed
  • transaction isolation level, serializable
  • transaction_timestamp
  • translate
  • trigger
  • trigger, for updating a derived tsvector column
  • trim
  • true
  • trunc
  • ts_debug
  • ts_headline
  • ts_lexize
  • ts_parse
  • ts_rank
  • ts_rank_cd
  • ts_rewrite
  • ts_stat
  • ts_token_type
  • tsquery (data type)
  • tsvector (data type)
  • tsvector concatenation
  • txid_current
  • txid_current_snapshot
  • txid_snapshot_xip
  • txid_snapshot_xmax
  • txid_snapshot_xmin
  • txid_visible_in_snapshot
  • type
  • type cast, type cast
  • u

  • UESCAPE, UESCAPE
  • Unicode escape, in identifiers
  • Unicode escape, in string constants
  • UNION
  • UNION, determination of result type
  • unique constraint
  • unnest
  • unqualified name
  • UPDATE
  • updating
  • upper
  • user, current
  • UUID
  • v

  • value expression
  • VALUES
  • VALUES, determination of result type
  • varchar
  • variance
  • variance, population
  • variance, sample
  • version
  • void
  • w

  • WHERE
  • width
  • width_bucket
  • window function, built-in
  • window function, invocation
  • window function, order of execution
  • WITH, in SELECT
  • x

  • xid
  • xmax
  • xmin
  • XML
  • XML export
  • XML option
  • xmlagg, xmlagg
  • xmlcomment
  • xmlconcat
  • xmlelement
  • xmlforest
  • xmlparse
  • xmlpi
  • xmlroot
  • xmlserialize
  • XPath

  • ISBN 9781906966041The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language ReferenceSee the print edition