By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 5.7.33 |
create table x
(
y varchar (25),
z varchar (10) generated always as (left(y, 19)) stored -- also virtual
);
CREATE INDEX x_z_ix ON x (z);