Looking at the mptt example ​http://code.djangoproject.com/wiki/ModifiedPreorderTreeTraversal it seemed a bit complicated for a normal user to understand. So i made my own, but considering i cannot group by makes aggregate functions hard to make this work nice, but magic-removal made it easier. Currently only works in postgesql and only tested in 8.1. Use at will and own RISK, but if/ when you improve it i would like to see it made available.

I attach the file and give a example here. Just add fields to this and it should work.

Remember to set the TABLE variable at the top of models to appname_model.

Example using project name myproject and app name pages.

from myproject.pages.models import Page

tree = Page.manager.all() # get entire tree

parent = Page.manager.get(pk=10) # get object you want to get the children of
children = parent.get_children() # returns empty dict if no children are found

parent = children[0].get_parent() # gets the parent