DEFAULT VALUE <> GENERATED ALWAYS AS STORED the DEFAULT value is not recalculated when the reference column are changed. is not an identical construction GENERATED ALWAYS AS STORED
reply:
They are in a separate list “Methods”. This approach was used for other databases long before generated columns were implemented in PostgreSQL.
====================
It has to do with the syntax of generated and that you can generate data in different ways. Calling those ways “methods” seems reasonable.
It's hard to argue with that. However, it is not quite clear to me, what origin are we talking about? I have worked with MS products and currently with PostgreSQL and have not encountered this interpretation.
The Shema-data thing is called the Boogyman pattern because teachers use it to scare students and illustrate what not to do when designing a data model. You can also find it abbreviated “EAV anti-pattern” where EAV stands for entity-attribute-value.