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?.
6 rows affected
| id | account | author | doc | users |
|---|---|---|---|---|
| 1 | 1 | Иванов | 3 | {Петя,Вася} |
| 2 | 1 | Иванов | 3 | {Иван} |
| 3 | 2 | Иванов | 3 | {Иван} |
| 4 | 2 | Сергеев | 3 | {Павел} |
| 5 | 2 | Сергеев | 3 | {Роман} |
| 6 | 1 | Сергеев | 3 | {Коля,Дима} |
| output |
|---|
| {"Сергеев" : { "1" : ["Коля","Дима"], "2" : ["Павел","Роман"] }} |
| {"Иванов" : { "2" : ["Иван"], "1" : ["Петя","Вася","Иван"] }} |