I am a member of the Charlotte Linux User Group and did a presentation on PostgreSQL at the SouthEast LinuxFest this past weekend. Our LUG table was right next to the PostgreSQL table this year, and I am guessing some of you will find the presentation of some interest. My discussion focused on using the ltree module instead of adjacency lists, nested sets and path enumeration to create and run queries against hierarchical category trees.