From: Ron Peterson <ron.peterson@yellowbank.com>
To: Gregory Brauer <greg@wildbrain.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Trees in SQL
Date: Fri, 24 May 2002 15:28:07 -0400
Message-ID: <20020524152806.A4111@yellowbank.com> (raw)
In-Reply-To: <3CEE87C1.3050501@wildbrain.com>
References: <3CEE818B.9020702@wildbrain.com>
<3CEE87C1.3050501@wildbrain.com>
On Fri, May 24, 2002 at 11:34:41AM -0700, Gregory Brauer wrote:
>
> I guess this page answers many of my questions...
>
> http://www.intelligententerprise.com/001020/celko1_1.shtml
>
> Anybody have comments on working with nested sets?
Note that Joe Celko concludes this article by saying "Although this procedure
works, you might want to use a language that has arrays in it, instead of
trying to stick to pure SQL."
The operations required to maintain this type of structure are expensive.
You might like to take a look at:
http://cddb.sai.msu.su/~megera/postgres/gist/
I haven't had a chance to try this out yet, but it looks promising.
As an added bonus, if you're Russian, the documentation is in Russian.
Unfortunately, if you're not Russian, the documentation is in Russian.
Otherwise, for the time being, I'd recomend procedural code, rather than pure
SQL.
--
Ron Peterson -o)
87 Taylor Street /\\
Granby, MA 01033 _\_v
https://www.yellowbank.com/ ----
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: ron.peterson@yellowbank.com, greg@wildbrain.com
Subject: Re: Trees in SQL
In-Reply-To: <20020524152806.A4111@yellowbank.com>
* 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