Re: Selecting tree data

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>, "Pat Maddox" <pergesu(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting tree data
Date: 2007-10-26 11:35:34
Message-ID: 64B2266B-EAA5-49EB-8B63-0CBB0A3B7E84@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 26, 2007, at 4:19 , Gregory Stark wrote:

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

Or adjacency list or nested set (or even nested intervals).

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-10-26 11:56:20 Re: INDEX and JOINs
Previous Message Reg Me Please 2007-10-26 11:10:42 Re: INDEX and JOINs