Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Selecting tree data
- From: "D. Dante Lorenso" <dante(at)lorenso(dot)com>
- To: Pat Maddox <pergesu(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Selecting tree data
- Date: Thu, 25 Oct 2007 21:01:53 -0500
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
- Follow-Ups:
- Re: Selecting tree data
- From: Gregory Stark
- Re: Selecting tree data
- References:
- Selecting tree data
- From: Pat Maddox
- Selecting tree data
- Prev by Date: Re: select count() out of memory
- Next by Date: Partitioning: how to exclude unrelated partitions?
- Previous by thread: Selecting tree data
- Next by thread: Re: Selecting tree data
- Indexes: