Re: Wrote a connect-by feature

Hi,

Am Mittwoch, 08. Aug 2007, 00:52:41 +0200 schrieb Bertram Scharpf:
> <http://www.bertram-scharpf.de/tmp/connectby.tar.gz>

I just extended it. Below an example.

Bertram

--------------------------------

select * from simp;

id | pid | nam
----+-----+----------
1 | | Abe
2 | 1 | Homer
3 | 2 | Bart
4 | 2 | Lisa
5 | 2 | Maggie
6 | | Ned
7 | 6 | Rod
8 | 6 | Todd
9 | | Clancy
10 | 9 | Ralph
11 | | Hyman
12 | 11 | Herschel
(12 rows)

select repeat(' ',t.lev)||(case when t.term then '`' else '|' end)||'-'||s.nam
from connectby_all( 'simp', 'id', 'pid', 'nam asc', null, null)
as t (id integer, pid integer, lev integer, pos integer, term boolean)
join simp as s on (t.id=s.id);

?column?
----------------
|-Abe
`-Homer
|-Bart
|-Lisa
`-Maggie
|-Clancy
`-Ralph
|-Hyman
`-Herschel
`-Ned
|-Rod
`-Todd
(12 rows)

--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de