New answers tagged

1 vote

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, ...
user avatar
  • 21.1k

Top 50 recent answers are included