Skip to content

Recursive query

recursive_query.png

WITH RECURSIVE descendientes AS (
    SELECT id, name, child_of
    FROM books
    WHERE child_of = 14
UNION ALL
    SELECT cat.id, cat.name, cat.child_of
    FROM books cat
          JOIN descendientes d ON cat.child_of = d.id
)
SELECT * FROM descendientes;