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

Re: SQL Query for Top Down fetching of childs

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>, "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL Query for Top Down fetching of childs
Date: 2004-01-29 10:27:51
Message-ID: 200401291027.52174.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

Responses

pgsql-sql by date

Next:From: MUKTADate: 2004-01-29 12:02:10
Subject:
Previous:From: azwaDate: 2004-01-29 09:05:29
Subject: Re: time series data

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