| PostgreSQL Reference Manual - Volume 1 - SQL Language Reference by The PostgreSQL Global Development Group Paperback (6"x9"), 716 pages ISBN 0954612027 RRP £32.00 ($49.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
5.2 Table Expressions
A table expression computes a table. The
table expression contains a FROM clause that is
optionally followed by WHERE, GROUP BY, and
HAVING clauses. Trivial table expressions simply refer
to a table on disk, a so-called base table, but more complex
expressions can be used to modify or combine base tables in various
ways.
The optional WHERE, GROUP BY, and
HAVING clauses in the table expression specify a
pipeline of successive transformations performed on the table
derived in the FROM clause. All these transformations
produce a virtual table that provides the rows that are passed to
the select list to compute the output rows of the query.
| ISBN 0954612027 | PostgreSQL Reference Manual - Volume 1 - SQL Language Reference | See the print edition |