Re: Selecting tree data - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Selecting tree data
Date
Msg-id CB82F344-CE35-4E17-B4B3-81975F4F3E7F@seespotcode.net
Whole thread Raw
In response to Re: Selecting tree data  ("Pat Maddox" <pergesu@gmail.com>)
Responses Re: Selecting tree data  ("Pat Maddox" <pergesu@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: cases in rules problem
Next
From: Rainer Bauer
Date:
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit