Building a path string

Question

Accepted Answer

The standard technique is to add a path column to the anchor (just the root's name) and concatenate in the recursive member. Each iteration appends the current node's name to the accumulated path. The result is a full ancestry string for every node in the tree without any post-processing. This same pattern works for building arrays of ancestors using array_append in PostgreSQL.