Documentation → PostgreSQL 8.2

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

Historical version. PostgreSQL 8.2 reached end of support in December 2011. See the current version for supported releases.

PostgreSQL 8.2.23 Documentation
Prev	Fast Backward		Fast Forward	Next

Chapter 7. Queries

Table of Contents

7.1. Overview

7.2. Table Expressions

7.2.1. The FROM Clause
7.2.2. The WHERE Clause
7.2.3. The GROUP BY and HAVING Clauses

7.3. Select Lists

7.3.1. Select-List Items
7.3.2. Column Labels
7.3.3. DISTINCT

7.4. Combining Queries

7.5. Sorting Rows

7.6. LIMIT and OFFSET

7.7. VALUES Lists

The previous chapters explained how to create tables, how to fill them with data, and how to manipulate that data. Now we finally discuss how to retrieve the data out of the database.

Prev	Home	Next
Deleting Data	Up	Overview

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.