"D. Dante Lorenso" <dante@xxxxxxxxxxx> writes: > Pat Maddox wrote: >> I'd like to store some tree data in my database. I want to be able to >> sort the data but maintain a tree structure.... >> Is it possible to pull all the data like that with one query? How do >> I need to structure the table, and what query do I have to run in >> order to make it happen? > > You need to look at the connectby function which is part of contrib. Or ltree. Depending on how static your data is and what else you need to do with it. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
