Selected references and readings for SQL and PostgreSQL .

Some white papers and technical reports from the original POSTGRES development team are available at the University of California, Berkeley, Computer Science Department web site .

SQL Reference Books

Judith Bowman, Sandra Emerson, and Marcy Darnovsky , The Practical SQL Handbook : Using SQL Variants , Fourth Edition, Addison-Wesley Professional, ISBN 0-201-70309-2, 2001.

C. J. Date and Hugh Darwen , A Guide to the SQL Standard : A user's guide to the standard database language SQL , Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997.

C. J. Date , An Introduction to Database Systems , Eighth Edition, Addison-Wesley, ISBN 0-321-19784-4, 2003.

Ramez Elmasri and Shamkant Navathe , Fundamentals of Database Systems , Fourth Edition, Addison-Wesley, ISBN 0-321-12226-7, 2003.

Jim Melton and Alan R. Simon , Understanding the New SQL : A complete guide , Morgan Kaufmann, ISBN 1-55860-245-3, 1993.

Jeffrey D. Ullman , Principles of Database and Knowledge : Base Systems , Volume 1, Computer Science Press, 1988.

PostgreSQL-Specific Documentation

Stefan Simkovics , Enhancement of the ANSI SQL Implementation of PostgreSQL , Department of Information Systems, Vienna University of Technology, November 29, 1998.

Discusses SQL history and syntax, and describes the addition of INTERSECT and EXCEPT constructs into PostgreSQL . Prepared as a Master's Thesis with the support of O. Univ. Prof. Dr. Georg Gottlob and Univ. Ass. Mag. Katrin Seyr at Vienna University of Technology.

A. Yu and J. Chen , The POSTGRES Group, The Postgres95 User Manual , University of California, Sept. 5, 1995.

Zelaine Fong , The design and implementation of the POSTGRES query optimizer , University of California, Berkeley, Computer Science Department.

Proceedings and Articles

Nels Olson , Partial indexing in POSTGRES: research project , University of California, UCB Engin T7.49.1993 O676, 1993.

L. Ong and J. Goh , "A Unified Framework for Version Modeling Using Production Rules in a Database System", ERL Technical Memorandum M90/33 , University of California, April, 1990.

L. Rowe and M. Stonebraker , " The POSTGRES data model ", Proc. VLDB Conference , Sept. 1987 .

P. Seshadri and A. Swami , "Generalized Partial Indexes (cached version) ", Proc. Eleventh International Conference on Data Engineering , 6-10 March 1995 , IEEE Computer Society Press, Cat. No.95CH35724, 1995, 420-7.

M. Stonebraker and L. Rowe , " The design of POSTGRES ", Proc. ACM-SIGMOD Conference on Management of Data , May 1986 .

M. Stonebraker, E. Hanson, and C. H. Hong , "The design of the POSTGRES rules system", Proc. IEEE Conference on Data Engineering , Feb. 1987 .

M. Stonebraker , " The design of the POSTGRES storage system ", Proc. VLDB Conference , Sept. 1987 .

M. Stonebraker, M. Hearst, and S. Potamianos , " A commentary on the POSTGRES rules system ", SIGMOD Record 18(3) , Sept. 1989.

M. Stonebraker , " The case for partial indexes ", SIGMOD Record 18(4) , Dec. 1989, 4-11.

M. Stonebraker, L. A. Rowe, and M. Hirohama , " The implementation of POSTGRES ", Transactions on Knowledge and Data Engineering 2(1) , IEEE, March 1990.

M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos , " On Rules, Procedures, Caching and Views in Database Systems ", Proc. ACM-SIGMOD Conference on Management of Data , June 1990 .