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. -- Dante ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster