In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL
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
PostgreSQL has many features not touched upon in this tutorial introduction, which has been oriented toward newer users of
Inheritance is a concept from object-oriented databases. It opens up interesting new possibilities of database design. Let's create two tables:
Recall the weather and cities tables from Chapter 2. Consider the following problem: You want to make sure that
Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single
Refer back to the queries in Section 2.6. Suppose the combined listing