Advertisement
Guest User

Untitled

a guest
Sep 10th, 2019
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH t(j) AS(VALUES($${".hw": "aafe",
  2. "pos": "v.i",
  3. "def": "to *turn, to *branch off",
  4. "sen": "aafe mai a:",
  5. "trs": "turn in here",
  6. "sen": "to aafe atu au",
  7. "trs": "I will branch off",
  8. "sen": "aafe mai",
  9. "trs": "turn in",
  10. "sen": "aafe atu",
  11. "trs": "turn there",
  12. "ety": "PN *afe 'deviate, turn aside'",
  13. "..re": "afeafe",
  14. "mor": "DUP",
  15. "pos": "v.i",
  16. "def": "to *branch off repeatedly",
  17. "sen": "kua afeafe a ia he hau he aoga",
  18. "trs": "he branched off repeatedly on his way home from school",
  19. "..af": "aafeaga",
  20. "mor": "aafe, aga {turn, Nom}",
  21. "pos": "n",
  22. "def": "*turn, turning point, *branch|ing",
  23. "sen": "ko e aafeaga a ia haana ke he hana maala",
  24. "trs": "that is his turning point to his plantation"}$$::jsonb)
  25. ), t1(j) AS (
  26.     SELECT j->jsonb_object_keys(j)
  27.     FROM t
  28.     GROUP BY 1
  29. )
  30. SELECT jsonb_agg(j)
  31. FROM t1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement