Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Selecting tree data

  • From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
  • To: Gregory Stark <stark(at)enterprisedb(dot)com>
  • Cc: "D. 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: Fri, 26 Oct 2007 07:35:34 -0400
  • Message-id: <64B2266B-EAA5-49EB-8B63-0CBB0A3B7E84(at)seespotcode(dot)net>

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
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group