On Mar 1, 2013, at 3:18, bhanu udaya wrote:
> I need a query to retrieve all the n level hierarchy when a Child node_id is
> passed. For example; if I pass 7, then i need parent nodes as below: I want
> to achive this in postgres database (version 9.2) without connect by prior.
>
> 3 5
> 5
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_i
