Hacker News new | past | comments | ask | show | jobs | submit login

I think those have to be explicitly refreshed, no?



Ah - they're are two types of generated columns

> There are two kinds of generated columns: stored and virtual. A stored generated column is computed when it is written (inserted or updated) and occupies storage as if it were a normal column. A virtual generated column occupies no storage and is computed when it is read. Thus, a virtual generated column is similar to a view and a stored generated column is similar to a materialized view (except that it is always updated automatically).

https://www.postgresql.org/docs/12/ddl-generated-columns.htm...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: