By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE people (
height_cm numeric,
height_in numeric GENERATED ALWAYS AS (height_cm * 2.54) STORED
);
CREATE TABLE
INSERT INTO people(height_cm)
VALUES(70),(80)
INSERT 0 2
SELECT * FROM people
| height_cm | height_in |
|---|---|
| 70 | 177.80 |
| 80 | 203.20 |
SELECT 2