Dan, > My existing tree implementation reflects the files contained on disk. > The > full pathname to a particlar file is obtained from the path to the > parent > directory. I am now considering putting this information into a > field in > the table. <snip> > Suggestions, comment, open ridicule, most welcome. thanks.
This is a fine implementation using the adjacency list model of tree design. However, I think you may find that the string-based tree implementation in /contrib/ltree is more suited to your purposes, and easier to maintain. -Josh Berkus ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
