Re: Modified Preorder Tree Traversal - Advanced question

[Roland Bouman]

Maybe im missing something, but i don't think it's all that complicated:

select c.*
from node p
inner join node c
on p.lft <= c.lft
and p.rgt => c.rgt
where p.region = [region of choice]
and c.zoom = [zoom of choice]

Now, use 'UK' for [region of choice]
and 3 for [zoom of choice].

e.g., this has nothing to do with leaf nodes: it has to do with nodes that have a zoom = 3