Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Selecting tree data
- From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- To: "Pat Maddox" <pergesu(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Selecting tree data
- Date: Fri, 26 Oct 2007 12:29:11 -0500
On Oct 26, 2007, at 10:56 , Pat Maddox wrote:
A bunch of options so far...but there's really no way to do this with standard SQL?
What do you mean by "standard SQL"? Trees aren't inherently relational.
I'm starting to feel I'm better off just pulling the data I need and then building the tree structure in my app code.
Part of the issue is how do you *store* the tree in the database. You have to encode that information somehow. These are all methods to do that.
Michael Glaesemann grzm seespotcode net
- Follow-Ups:
- Re: Selecting tree data
- From: Pat Maddox
- Re: Selecting tree data
- References:
- Selecting tree data
- From: Pat Maddox
- Re: Selecting tree data
- From: D. Dante Lorenso
- Re: Selecting tree data
- From: Gregory Stark
- Re: Selecting tree data
- From: Michael Glaesemann
- Re: Selecting tree data
- From: Pat Maddox
- Selecting tree data
- Prev by Date: Re: cases in rules problem
- Next by Date: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
- Previous by thread: Re: Selecting tree data
- Next by thread: Re: Selecting tree data
- Indexes: