Michael Lewis schrieb am 28.10.2021 um 22:44:
On Thu, Oct 28, 2021 at 1:57 PM SQL Padawan <sql_padawan@xxxxxxxxxxxxxx <mailto:sql_padawan@xxxxxxxxxxxxxx>> wrote: I presume that VIRTUAL GENERATED columns are on the to-do list? https://www.postgresql.org/docs/current/ddl-generated-columns.html Is this not what you want?
Those are persisted/stored generated columns. They are only evalated when a row is inserted or updated. Virtual generated columns are evaluated each time you access, so they could use volatile functions.
