Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH t(j) AS(VALUES($${".hw": "aafe",
- "pos": "v.i",
- "def": "to *turn, to *branch off",
- "sen": "aafe mai a:",
- "trs": "turn in here",
- "sen": "to aafe atu au",
- "trs": "I will branch off",
- "sen": "aafe mai",
- "trs": "turn in",
- "sen": "aafe atu",
- "trs": "turn there",
- "ety": "PN *afe 'deviate, turn aside'",
- "..re": "afeafe",
- "mor": "DUP",
- "pos": "v.i",
- "def": "to *branch off repeatedly",
- "sen": "kua afeafe a ia he hau he aoga",
- "trs": "he branched off repeatedly on his way home from school",
- "..af": "aafeaga",
- "mor": "aafe, aga {turn, Nom}",
- "pos": "n",
- "def": "*turn, turning point, *branch|ing",
- "sen": "ko e aafeaga a ia haana ke he hana maala",
- "trs": "that is his turning point to his plantation"}$$::jsonb)
- ), t1(j) AS (
- SELECT j->jsonb_object_keys(j)
- FROM t
- GROUP BY 1
- )
- SELECT jsonb_agg(j)
- FROM t1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement