Re: [SQL] SQL Query for Top Down fetching of childs

2004-01-29 Thread Kumar
ED]> 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 par

Re: [SQL] SQL Query for Top Down fetching of childs

2004-01-29 Thread Richard Huxton
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

[SQL] SQL Query for Top Down fetching of childs

2004-01-28 Thread Kumar
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   CREATE TABLE organization(  entity_id int4,  entity_name varchar(100),  entity_type