Re: Updating a nested set

2003-07-29 Thread olinux
I'm about to dig a bit deeper into Celko's articles and love the idea of nested sets. Still trying to pull some time to start implementing this myself. Anyway, I don't really have an answer for you but you might want to take a look at PEAR::DB_NestedSet, as it sounds very able to work with nested

Updating a nested set

2003-07-23 Thread Knepley, Jim
I'm basing some work on Joe Celko's excellent idea of using nested sets to represent an organizational structure as opposed to an adjacency list. By and large it's a great idea, but not without its pitfalls. I'm writing now to ask your collective opinion of the best practice. I've got my nested se