postgres parent/child in on table

Forum Moderators: open

Message Too Old, No Replies

postgres parent/child in on table

brnco

11:01 pm on Feb 8, 2008 (gmt 0)

I have a table like:

id Ś name Ś id_parent Ś id_child
1 Ś Team Lead Ś 10 Ś 0
2 Ś Senio Prg Ś 20 Ś 10
3 Ś Call centre Ś 30 Ś 20
4 Ś Programmer Ś 40 Ś 10

etc...

I would like to make a select that will order the data same way as left join. That means: Below Team Lead should be Senio Prg and Programmer.

id_child rows will be always below id_parent

Can you help me with this please? I know how to solve it with 2 Select statements but I don't think it's the most comfortable way.

Thanks in advance

ZydoSEO

10:08 pm on Feb 9, 2008 (gmt 0)

It would help if you would explain the purpose of the fields in your table. I have no clue what the data represents. Where do you get the values in id_parent and id_child? Are those other 'id' values from this same table?

It would also help if you showed what order the rows should be output in by the query you are requesting.