- 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>>>

PostgreSQL Reference Manual

Volume 1A: The SQL Language

for version 9.0.1

September 2010

The PostgreSQL Global Development Group

(1) http://www.network-theory.co.uk/postgresql/

(2) Actually, PostgreSQL uses the default B-tree operator class for the expression's data type to determine the sort ordering for ASC and DESC. Conventionally, data types will be set up so that the < and > operators correspond to this sort ordering, but a user-defined data type's designer could choose to do something different.

(3) The conversion names follow a standard naming scheme: The official name of the source encoding with all non-alphanumeric characters replaced by underscores, followed by _to_, followed by the similarly processed destination encoding name. Therefore, the names might deviate from the customary encoding names.

(4) 60 if leap seconds are implemented by the operating system

(5) The reason for this step is to support function-style cast specifications in cases where there is not an actual cast function. If there is a cast function, it is conventionally named after its output type, and so there is no need to have a special case. See CREATE CAST for additional commentary.

(6) Essentially, a predicate-locking system prevents phantom reads by restricting what is written, whereas MVCC prevents them by restricting what is read.

(7) Examples in this section are drawn from the regression test database after doing a VACUUM ANALYZE, using 8.2 development sources. You should be able to get similar results if you try the examples yourself, but your estimated costs and row counts might vary slightly because ANALYZE's statistics are random samples rather than exact.

(8) You can get the effect of disabling foreign keys by using the --disable-triggers option--but realize that that eliminates, rather than just postpones, foreign key validation, and so it is possible to insert bad data if you use it.

(9) trims trailing spaces from CHARACTER values before counting

(10) differences regarding literal interpretation

(11) intentionally omitted

(12) foreign and unique keys only

(13) no partial match yet

(14) partially supported

(15) intentionally omitted

(16) most forms supported

(17) some forms supported

(18) function exists, but some options missing

(19) only some syntax variants supported

This document was generated using the texi2html translator version 1.54.

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