reporting tree into separate columns

Поиск
Список
Период
Сортировка
От Ibrahim Shaame
Тема reporting tree into separate columns
Дата
Msg-id CAJOWwD615LZV9+cppcVdajXJpn25VnjCmymMZrQxdwpfU9Ccsg@mail.gmail.com
обсуждение исходный текст
Ответы Re: reporting tree into separate columns  (Didier Gasser-Morlay <didiergm@gmail.com>)
Re: reporting tree into separate columns  (Tomek <tomekphotos@gmail.com>)
Список pgsql-novice
I have the following query which gives me family tree

with recursive x (jina,namba,nasaba_1)

as (

select jina ||' '|| baba ||' '|| babu AS jina,namba, nasaba_1

from majina2

where nasaba_1 = 0

union all

select x.jina ||' '|| ' - '|| e.jina || ' ' || baba || ' ' || babu, e.namba, e.nasaba_1

from majina2 e, x

where e.nasaba_1 = x.namba

)

select jina,namba,nasaba_1,(length(jina)-length(replace(jina,'-','')))/length('-') AS depth

from x

order by 1;


And I get the following result:


jinanambaNasaba_1depth
Asia Khamis Haji 10000200
Asia Khamis Haji - Azida Makame Haji 1001281000021
Asia Khamis Haji - Ishak Makame Haji 1001271000021
Asia Khamis Haji - Ishak Makame Haji - Alia Ishak Makame 1002501001272
Asia Khamis Haji - Ishak Makame Haji - Ibrahim Ishak Makame 1002511001272
Asia Khamis Haji - Khamis Abdalla Ali 1001261000021
Asia Khamis Haji - Mwajuma Abdalla 1001251000021
Asia Khamis Haji - Namwira Abdalla Mosi 1001241000021


But what I want to get is to report the first column in different columns according to depth (last column)


Any suggestions


Thanks

Ibrahim Shaame

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Run a transaction block through SPI_execute
Следующее
От: Didier Gasser-Morlay
Дата:
Сообщение: Re: reporting tree into separate columns