Chapter 13. The Query Language

Table of Contents

Concepts

Creating a New Class

Populating a Class with Instances

Querying a Class

Redirecting SELECT Queries

Joins Between Classes

Updates

Deletions

Using Aggregate Functions

NOTE: This chapter must go into depth on each area of the query language. Currently a copy of the tutorial. - thomas 1998-01-12

The Postgres query language is a variant of SQL3. It has many extensions such as an extensible type system, inheritance, functions and production rules. Those are features carried over from the original Postgres query language, PostQuel. This section provides an overview of how to use Postgres SQL to perform simple operations. This manual is only intended to give you an idea of our flavor of SQL and is in no way a complete tutorial on SQL. Numerous books have been written on SQL. For instance, consult [MELT93] or [DATE93]. You should also be aware that some features are not part of the ANSI standard.