From: Richard Huxton <dev@archonet.com>
To: Kumar <sgnerd@yahoo.com.sg>
To: psql <pgsql-sql@postgresql.org>
Subject: Re: SQL Query for Top Down fetching of childs
Date: Thu, 29 Jan 2004 10:27:51 +0000
Message-ID: <200401291027.52174.dev@archonet.com> (raw)
In-Reply-To: <00ad01c3e62e$b70ccf60$7502a8c0@hdsc.com>
References: <00ad01c3e62e$b70ccf60$7502a8c0@hdsc.com>
On Thursday 29 January 2004 06:11, Kumar wrote:
> Dear Friends,
>
> Postgres 7.3.4 on RH Linux 7.2.
>
> I need a query to get the Childs of a parent (Top down analysis). Need to
> list all the departments(Childs) of a parent organization. The table
> structure is
Two places to look for examples:
1. the contrib/tablefunc folder has an example of this sort of thing
2. search the mailing list articles for CONNECT BY (oracle's name for this
sort of thing) or "tree"
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, sgnerd@yahoo.com.sg
Subject: Re: SQL Query for Top Down fetching of childs
In-Reply-To: <200401291027.52174.dev@archonet.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