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