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