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 114 times
2
a_horse_with_no_name
- 497,550
- 91
- 775
- 843
A_Wen
- 733
- 2
- 6
- 8
-
Soon: https://www.2ndquadrant.com/en/blog/generated-columns-in-postgresql-12/ – Christophe Roussy Jul 09 '19 at 08:48