Re: [pgadmin-support] GetHierarchy

2013-02-28 Thread Craig Ringer
On 03/01/2013 12:14 PM, bhanu udaya wrote: > > I need a query to retrieve all the n level hierarchy when a Child > node_id is passed. I think you're probably looking for the pgsql-general mailing list or Stack Overflow. This list is focused on the PgAdmin-III program. -- Craig Ringer

Re: [pgadmin-support] GetHierarchy

2013-02-28 Thread bhanu udaya
Greetings ! I have a hierarchy table with two attributes : Parent_ID, Child_ID with the sample data (can go upto n-level) as below: ParentID ChildID 1 3 1 4 3 5 5 6 6 7 I need a query to retrieve all the n level hierarchy when a Child node_id