2 ms·
Thank you for this tip. This sounds horrendous in terms of maintainability but nice to see it's possible.
by maweki 7y ago
Thank you for this tip. This sounds horrendous in terms of maintainability but nice to see it's possible.
- radiowave 7y agoI 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 )