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: (view raw or whole 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


pgsql-sql by date

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

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