From: Victor Yegorov <viy@pirmabanka.lv>
To: pgsql-sql@postgresql.org
Subject: Re: Querying Hierarchical Data
Date: Mon, 3 Mar 2003 18:34:36 +0200
Message-ID: <20030303163436.GG9377@pirmabanka.lv> (raw)
In-Reply-To: <D4z8a.8540$X14.581155@news2.telusplanet.net>
References: <D4z8a.8540$X14.581155@news2.telusplanet.net>
* Eric <someone@somewhere.com> [03.03.2003 17:10]:
> Hi,
>
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
>
> Any help is appreciated
I've have the same problem recently.
I've combined nested sets with adjacency list model, perfect solution, IMHO.
Read more about nested sets here:
http://www.brasileiro.net:8080/postgres/cookbook/view-recipes.adp?section_id=310&format=long
--
Victor Yegorov
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: viy@pirmabanka.lv
Subject: Re: Querying Hierarchical Data
In-Reply-To: <20030303163436.GG9377@pirmabanka.lv>
* 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