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"
In response to
pgsql-sql by date
|Next:||From: MUKTA||Date: 2004-01-29 12:02:10|
|Previous:||From: azwa||Date: 2004-01-29 09:05:29|
|Subject: Re: time series data|