computed column
A column in a query's answer whose value is calculated from other values, such as price times quantity.
In more detail
The table does not store it; the database works it out for each row as the query runs. Give it a name with AS.
Related terms
- AS — The keyword that gives a column, expression or table a new name in a query.
- result set — The table of rows a query returns, which exists only as the answer and is not stored anywhere.
Taught in
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling
- Inner Joins And Table Aliases — PostgreSQL, Indexing & Relational Data Modeling