diff options
| author | Peter Eisentraut | 2019-03-30 07:13:09 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2019-03-30 07:15:57 +0000 |
| commit | fc22b6623b6b3bab3cb057ccd282c2bfad1a0b30 (patch) | |
| tree | cda5092955ece5d547d5517ed56a3d480f199d25 /src/include/optimizer | |
| parent | 6b8b5364ddd0e4d882562615c6b6c28638ade9f2 (diff) | |
Generated columns
This is an SQL-standard feature that allows creating columns that are
computed from expressions rather than assigned, similar to a view or
materialized view but on a column basis.
This implements one kind of generated column: stored (computed on
write). Another kind, virtual (computed on read), is planned for the
future, and some room is left for it.
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/b151f851-4019-bdb1-699e-ebab07d2f40a@2ndquadrant.com
Diffstat (limited to 'src/include/optimizer')
| -rw-r--r-- | src/include/optimizer/plancat.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/include/optimizer/plancat.h b/src/include/optimizer/plancat.h index c337f047cb7..c556e0f2589 100644 --- a/src/include/optimizer/plancat.h +++ b/src/include/optimizer/plancat.h @@ -71,4 +71,6 @@ extern double get_function_rows(PlannerInfo *root, Oid funcid, Node *node); extern bool has_row_triggers(PlannerInfo *root, Index rti, CmdType event); +extern bool has_stored_generated_columns(PlannerInfo *root, Index rti); + #endif /* PLANCAT_H */ |