From: Kumar <sgnerd@yahoo.com.sg>
To: Richard Huxton <dev@archonet.com>
To: psql <pgsql-sql@postgresql.org>
Subject: Re: SQL Query for Top Down fetching of childs
Date: Thu, 29 Jan 2004 17:52:35 +0530
Message-ID: <015701c3e662$9536dcd0$7502a8c0@hdsc.com> (raw)
References: <00ad01c3e62e$b70ccf60$7502a8c0@hdsc.com>
<200401291027.52174.dev@archonet.com>
Thanks a lot Mr.Richard Huxton. It managed to find a similar one and
modified to my need. It is working fine. Thanks a lot
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Kumar" <sgnerd@yahoo.com.sg>; "psql" <pgsql-sql@postgresql.org>
Sent: Thursday, January 29, 2004 3:57 PM
Subject: Re: [SQL] SQL Query for Top Down fetching of childs
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
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: sgnerd@yahoo.com.sg, dev@archonet.com
Subject: Re: SQL Query for Top Down fetching of childs
In-Reply-To: <015701c3e662$9536dcd0$7502a8c0@hdsc.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