Re: Selecting tree data

[Gregory Stark <stark(at)enterprisedb(dot)com>]

"D. Dante Lorenso" <dante(at)lorenso(dot)com> 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