New answers tagged tree
1
vote
Accepted
how to update the tree path of the table in PostgreSQL
Here is one example, you probably need to adjust it slightly:
create table tmp (id int, parent_id int, tree_path_id text);
insert into tmp (id, parent_id, tree_path_id)
with recursive t (id, ...
- 21.1k
Top 50 recent answers are included