GetHierarchy

[bhanu udaya <udayabhanu1984@xxxxxxxxxxx>]

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