Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> I prefer my tables to be fully normalized.

Computed columns essentially make the base table into a transparent materialized view over the (noncomputed) “real” base table. But it's closer to an ideal materialized view than actual Postgres materialized views because it self-refreshes on need. But, conceptually, it fills the same role as a matview.



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

Search: