You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WITH RECURSIVE
S AS (SELECT 0 DEPTH, ID
FROM TMP
UNION ALL
SELECT S.DEPTH + 1, http://TMP.ID
FROM TMP
JOIN S ON TMP.PARENT_ID = http://S.ID
WHERE S.DEPTH < 10)
SELECT * FROM S
Submitted by: Alexander Tyutik (tut)
Votes: 7
It would be nice to enhance syntax of recursive CTE to something like this:
WITH [RECURSIVE [MAX DEEP X]]
Because now we do not have any effective solution for limitation such recursive queries by deep.
The text was updated successfully, but these errors were encountered: