Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. select ROW(qid::integer,a.prev_qid::integer) ids from getchildren(39) b
  2. cross join lateral(select qid prev_qid from getprevquestion(b.qid)
  3. )a
  4.  
  5. (42,39)
  6. (43,39)
  7. (48,42)
  8. (49,42)
  9. (50,42)
  10. (51,43)
  11. (52,43)
  12. (53,43)
  13.  
  14. ((42,39),(43,39),(48,42),(49,42),(50,42),(51,43),(52,43),(53,43))
  15.  
  16. select array_agg(ids) from (
  17. select ROW(qid::integer,a.prev_qid::integer) ids from getchildren(39) b
  18. cross join lateral(select qid prev_qid from getprevquestion(b.qid)
  19. )a
  20. )b
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement