python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - ltree

Get all ltree nodes at depth

I have an ltree column containing a tree with a depth of 3. I'm trying to write a query that can select all children at a specific depth (level 1 = get all parents, 2 = get all children, 3 = get all g...
test-img

Optimum

postgresql

hierarchical-data

postgresql-11

ltree

Votes: 0

Answers: 1

Latest Answer

The only index that could support your query is a simple b-tree index on an expression. create index on hierarchies((nlevel(path))) Note however that it is quite possible for the planner to choose a ...
test-img

klin

Posts

Questions

Blogs

Jobs