From: knut.suebert@web.de
To: pgsql-sql@postgresql.org
Subject: Support for "nested sets" and PHP (Re: Recursive select)
Date: Fri, 8 Mar 2002 19:38:11 +0100
Message-ID: <20020308183811.GA7536@web.de> (raw)
In-Reply-To: <c0d87ec0.0110311714.3c2d0de8@posting.google.com>
References: <20011029154754.A11730@cc.usu.edu>
<c0d87ec0.0110311714.3c2d0de8@posting.google.com>
--CELKO-- schrieb:
> The usual example of a tree structure in SQL books is called an
> adjacency list model and it looks like this:
> Another way of representing trees is to show them as nested sets.
Hello,
I thought a while about those nested sets to avoid recursive selects.
Made a few functions. Some of the expensive stuff seems to be solved
by introducing a 3rd column called "lvl".
If you are interested in, you can find it at
http://www.net-one.de/~ks/WOoK/
by taking a look at "The PostrgreSQL side". Celko's original text is
also there.
Some stuff may be interesting for using PHP to edit PostgreSQL's
tables. But that part is incomplete, yet.
I'd be happy to get your thoughts to improve the handling (and my
understanding) of "nested sets".
Bye,
Knut Sübert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: knut.suebert@web.de
Subject: Re: Support for "nested sets" and PHP (Re: Recursive select)
In-Reply-To: <20020308183811.GA7536@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox