create view v as
select k, x, f + 10, sqrt(f) as root_f
from t;
...
Table "public.t"
Column | Type | Modifiers
--------+------------------+-----------
k | integer | not null
x | integer | not null
f | double precision |
Indexes:
"t_pkey" PRIMARY KEY, btree (k)
Check constraints:
"t_x_check" CHECK (x > 0)
View "public.v"
Column | Type | Modifiers
----------+------------------+-----------
k | integer |
x | integer |
?column? | double precision |
root_f | double precision |
|
- k, x: Preserve type but not constraints (PK, check).
- f + 10: Name not provided, so Postgres fills in a useless one.
- sqrt(f) as root_f: Name specified in view.
|