| From: | bhanu udaya <udayabhanu1984(at)hotmail(dot)com> |
|---|---|
| To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: GetHierarchy |
| Date: | 2013-03-01 04:14:15 |
| Message-ID: | COL002-W71D7AC2CA77B96E97DCC1D3FF0@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
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.
ParentID
ChildID
3 5
5 6
6 7
Any reply on this is great help.
Thanks and REgards
RAdha Krishna
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2013-03-01 04:33:04 | Re: GetHierarchy |
| Previous Message | bhanu udaya | 2013-03-01 02:18:01 | GetHierarchy |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2013-03-01 04:33:04 | Re: GetHierarchy |
| Previous Message | bhanu udaya | 2013-03-01 02:18:01 | GetHierarchy |