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 versions (id integer, version text);
insert into versions
values
(1,'0.9'),
(2,'1.0'),
(3,'0.9.1'),
(4,'1.1'),
(5,'0.9.9'),
(6,'0.9.10');
CREATE TABLE
INSERT 0 6
SELECT id, version
FROM versions
ORDER BY string_to_array(version, '.')::int[];
| id | version |
|---|---|
| 1 | 0.9 |
| 3 | 0.9.1 |
| 5 | 0.9.9 |
| 6 | 0.9.10 |
| 2 | 1.0 |
| 4 | 1.1 |
SELECT 6