How to work with Ltree?

Question

PostgreSQL

I want to fasten Ltree, I have little experience, tree search is very easy, judging by the help.
But does anyone have examples of how to migrate branches and delete a branch?
Example: There is a department with employees that belongs to a subdivision and I need to transfer this department to another subdivision.

Answer 1

This is the implementation of the materialized path. A branch is deleted if it has no items. Move - move each element. subpath function to help for example

update tablename set tree = concat('newbranch.', subpath(tree, 1))::ltree where tree <@ 'origbranch';