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, ...
Top 50 recent answers are included
Related Tags
tree × 58postgresql × 24
database-design × 12
recursive × 12
mysql × 10
hierarchy × 10
cte × 7
query × 5
index × 3
graph × 3
btree × 3
sql-server × 2
mongodb × 2
optimization × 2
join × 2
stored-procedures × 2
foreign-key × 2
ms-access × 2
json × 2
relational-theory × 2
count × 2
erd × 2
performance × 1
query-performance × 1
sql-server-2016 × 1