Topic

Generated columns

Database columns whose values are computed from an expression over other columns in the same row, either stored on write or computed on read.

Current clusters

build1 publisher

Indexing a PostgreSQL 18 generated column requires writing STORED

PostgreSQL 18 makes generated columns virtual unless the definition says STORED, and a virtual column cannot be indexed directly. Tests on 18.3 by the Schemity ERD tool's maker still favour them over triggers for same-row values, if indexed ones are written STORED.

Publishers:dev.to

Reality

Evidence58
Adoption: Insufficient
Hype gap0
Incentives25
Confidence60