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
INSERT 0 1
id | fquestions |
---|---|
1 | [{"id": "1", "name": "Вопрос 1? ", "optionSections": [{"id": "11", "questionOptions": [{"id": "111", "value": "Вариант 1"}, {"id": "112", "value": "Вариант 2 "}]}]}, {"id": "2", "name": "Вопрос 2", "optionSections": [{"id": "22", "questionOptions": [{"id": "221", "value": "1"}, {"id": "222", "value": "2"}]}]}] |
SELECT 1
id | question_name |
---|---|
1 | "Вопрос 1? " |
1 | "Вопрос 2" |
SELECT 2