postgresql: вернуть и отсортировать часть json - Stack Overflow на русском

PHOTO EMBED

Sat Sep 24 2022 18:06:48 GMT+0000 (Coordinated Universal Time)

Saved by @KHOMBAT

SELECT res::json->'abc'->'c' FROM main WHERE id = 3;
получаю:
             [
             [69, "text_05", "m n o"],
             [4, " text_02", "def"],
             [1, "text_01", "abc "],
             [48, " text_04 ", "jkl"],
             [5, " text_03 ", " ghi"],
             [82, "text_06  ", " pq r "]
             ]
content_copyCOPY

https://ru.stackoverflow.com/questions/1451294/postgresql-вернуть-и-отсортировать-часть-json