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: 2007-10-26 17:29:11
Message-ID: CB82F344-CE35-4E17-B4B3-81975F4F3E7F@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Hixson 2007-10-26 17:34:32 Re: change format of logging statements?
Previous Message Rainer Bauer 2007-10-26 17:09:26 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit