By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| myarray | d1 | d2 |
|---|---|---|
| {{1,10,100},{2,11,101}} | 1 | 1 |
| {{1,10,100},{2,11,101}} | 1 | 2 |
| {{1,10,100},{2,11,101}} | 1 | 3 |
| {{1,10,100},{2,11,101}} | 2 | 1 |
| {{1,10,100},{2,11,101}} | 2 | 2 |
| {{1,10,100},{2,11,101}} | 2 | 3 |
| array_agg |
|---|
| {1,10,100} |
| {2,11,101} |