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 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 6
6 7
Any reply on this is great help.
Thanks and REgards
RAdha Krishna
