parent_id_tree.sql

parent_id_tree.sql

WITH RECURSIVE epc (id, parent_id, anchor) as (
    SELECT id, parent_id, anchor FROM table WHERE parent_id = 32
    UNION ALL
    SELECT pc.id, pc.parent_id, pc.anchor FROM table pc
                                        INNER JOIN epc on pc.parent_id = epc.id
)
SELECT * FROM epc order by id