Guest User

Untitled

a guest
Jul 1st, 2017
610
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     items.id, items.name,
  3.     COALESCE(
  4.          (
  5.             SELECT array_to_json(array_agg(row_to_json(subitems)))
  6.             FROM (
  7.                 SELECT subitems.id, subitems.name
  8.                 FROM subitems
  9.                 WHERE subitems.item_id = items.id
  10.             ) subitems
  11.          ),
  12.         '[]'
  13.     ) AS subitems
  14. FROM items
Advertisement
Add Comment
Please, Sign In to add comment