Recursive SQL Queries with PostgreSQL

Re:Recursive SQL Queries with PostgreSQL by maweki on Monday March 16, 2020 @05:55AM (#22591329)

Thank you for this tip. This sounds horrendous in terms of maintainability but nice to see it's possible.

[ Parent | on HN ]

Re:Recursive SQL Queries with PostgreSQL by radiowave on Monday March 16, 2020 @06:08AM (#22591378)

I just found it in my notes. I don't think it looks too bad - everything you were going to do in the recursive part, you just do inside the subquery instead.

  WITH RECURSIVE my_cte AS (
    SELECT foo, bar FROM whatever
    UNION ALL
    SELECT (s).*
    FROM my_cte, LATERAL (
      SELECT ... -- refer to my_cte multiple times here
    ) s
  )

[ Parent | on HN ]