Skip site navigation (1) Skip section navigation (2)

Re: SQL Query for Top Down fetching of childs

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "Richard Huxton" <dev(at)archonet(dot)com>,"psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL Query for Top Down fetching of childs
Date: 2004-01-29 12:22:35
Message-ID: 015701c3e662$9536dcd0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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(at)archonet(dot)com>
To: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>; "psql" <pgsql-sql(at)postgresql(dot)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
> > 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(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly

In response to

pgsql-sql by date

Next:From: Bruno Wolff IIIDate: 2004-01-29 12:52:40
Subject: Re: limit 1 and functional indexes
Previous:From: email listsDate: 2004-01-29 12:18:08
Subject: query not using index for descending records?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group