ALTER TABLE formation ADD p varchar(20) GENERATED ALWAYS AS (DAT_FM -> '$.position') VIRTUAL;
ALTER TABLE formation ADD c decimal(12,3) GENERATED ALWAYS AS (DAT_FM -> '$.c') VIRTUAL;
Does Postgres support to create a virtual column like MySQL?
Asked
Active
Viewed 120 times
2
A_Wen
- 783
- 2
- 6
- 8
-
Soon: https://www.2ndquadrant.com/en/blog/generated-columns-in-postgresql-12/ – Christophe Roussy Jul 09 '19 at 08:48