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.
[bowman01] The Practical SQL Handbook. Using SQL Variants. Fourth Edition. ISBN 0-201-70309-2. Addison-Wesley Professional. 2001.
[date97] A Guide to the SQL Standard. A user's guide to the standard database language SQL. Fourth Edition. ISBN 0-201-96426-0. Addison-Wesley. 1997.
[date04] An Introduction to Database Systems. Eighth Edition. ISBN 0-321-19784-4. Addison-Wesley. 2003.
[elma04] Fundamentals of Database Systems. Fourth Edition. ISBN 0-321-12226-7. Addison-Wesley. 2003.
[melt93] Understanding the New SQL. A complete guide. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.
[ull88] Principles of Database and Knowledge-Base Systems. Classical Database Systems. Computer Science Press. 1988.
[sqltr-19075-6] SQL Technical Report. Part 6: SQL support for JavaScript Object Notation (JSON). First Edition. 2017.
[sim98] Enhancement of the ANSI SQL Implementation of PostgreSQL. Department of Information Systems, Vienna University of Technology. Vienna, Austria. November 29, 1998.
[yu95] The Postgres95. User Manual. University of California. Berkeley, California. Sept. 5, 1995.
[fong] The design and implementation of the POSTGRES query optimizer. University of California, Berkeley, Computer Science Department.
[berenson95] βA Critique of ANSI SQL Isolation Levelsβ. ACM-SIGMOD Conference on Management of Data, June 1995.
[hell18] βLooking Back at Postgresβ. Making Databases Work. ISBN 978-1-947487-19-2. Association for Computing Machinery and Morgan & Claypool. 2018.
[olson93] Partial indexing in POSTGRES: research project. UCB Engin T7.49.1993 O676. University of California. Berkeley, California. 1993.
[ong90] βA Unified Framework for Version Modeling Using Production Rules in a Database Systemβ. ERL Technical Memorandum M90/33. University of California. Berkeley, California. April, 1990.
[ports12] βSerializable Snapshot Isolation in PostgreSQLβ. VLDB Conference, August 2012.
[rowe87] βThe POSTGRES data modelβ. VLDB Conference, Sept. 1987.
[seshadri95] βGeneralized Partial Indexesβ. Eleventh International Conference on Data Engineering, 6β10 March 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 1995. 420β7.
[ston86] βThe design of POSTGRESβ. ACM-SIGMOD Conference on Management of Data, May 1986.
[ston87a] βThe design of the POSTGRES rules systemβ. IEEE Conference on Data Engineering, Feb. 1987.
[ston87b] βThe design of the POSTGRES storage systemβ. VLDB Conference, Sept. 1987.
[ston89] βA commentary on the POSTGRES rules systemβ. SIGMOD Record 18(3). Sept. 1989.
[ston89b] βThe case for partial indexesβ. SIGMOD Record 18(4). Dec. 1989. 4β11.
[ston90a] βThe implementation of POSTGRESβ. Transactions on Knowledge and Data Engineering 2(1). IEEE. March 1990.
[ston90b] βOn Rules, Procedures, Caching and Views in Database Systemsβ. ACM-SIGMOD Conference on Management of Data, June 1990.
[ston92] β An overview of the Sequoia 2000 project β. Digest of Papers COMPCON Spring 1992. 1992. 383β388.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.