.......................................................................395 25.2.1. Statistics Collection Configuration .................................................................395 25.2.2. Viewing hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

.......................................................................449 26.2.1. Statistics Collection Configuration ..........................................................450 26.2.2. Viewing Collected hierarchical database. A more modern development is the object- oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

.......................................................................654 27.2.1. Statistics Collection Configuration .................................................................654 27.2.2. Viewing hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

.......................................................................478 26.2.1. Statistics Collection Configuration .................................................................478 26.2.2. Viewing hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

.......................................................................395 25.2.1. Statistics Collection Configuration .................................................................395 25.2.2. Viewing hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 2.3 slice up the data in different ways using different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering

.......................................................................490 26.2.1. Statistics Collection Configuration ..........................................................491 26.2.2. Viewing Collected hierarchical database. A more modern development is the object- oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 5

.......................................................................522 26.2.1. Statistics Collection Configuration .................................................................522 26.2.2. Viewing hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6

.......................................................................618 27.2.1. Statistics Collection Configuration ..........................................................618 27.2.2. Viewing Collected hierarchical database. A more modern development is the object- oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 5

hierarchical database. A more modern development is the object-oriented database. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific (although they can be explicitly sorted for display). Tables are grouped into databases, and a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 2 slice up the data in different ways using different OVER clauses, but they all act on the same collection of rows defined by this virtual table. We already saw that ORDER BY can be omitted if the ordering