In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL

Inheritance is a concept from object-oriented databases. It opens up interesting new possibilities of database design. Let's create two tables:

PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of

A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of

Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single

Recall the weather and cities tables from Chapter 2. Consider the following problem: You want to make sure that

Refer back to the queries in Section 2.6. Suppose the combined listing