From: Oleg Bartunov <oleg@sai.msu.su>
To: Christian Brink <cb@onsitetech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Is this the most efficent way to child nodes off a N-ary
Date: Thu, 14 Feb 2002 22:37:29 +0300 (GMT)
Message-ID: <Pine.GSO.4.44.0202142236330.9731-100000@ra.sai.msu.su> (raw)
In-Reply-To: <a4h183$1ud8$1@jupiter.hub.org>
Christian,
take a look at our contrib/tree module, available from
http://www.sai.msu.su/~megera/postgres/gist/
Oleg
On Thu, 14 Feb 2002, Christian Brink wrote:
> I have created this SQL statment, used to pull the child/leaf nodes off of a
> N-ary node structure in PostgreSQL.
>
> Is my premise all wrong?
>
> Is this efficent as a SQL select?
>
> Should this be done in my code (something I try to avoid for abstraction
> reasons)?
>
> "SELECT DISTINCT t1.node_id FROM node t1 WHERE NOT EXISTS (SELECT
> t1.node_id FROM node t2 WHERE t1.node_id = t2.parent_id);"
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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: oleg@sai.msu.su, cb@onsitetech.com
Subject: Re: Is this the most efficent way to child nodes off a N-ary
In-Reply-To: <Pine.GSO.4.44.0202142236330.9731-100000@ra.sai.msu.su>
* 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