Thread: connectby

connectby

From
sector119@mail.ru
Date:
hi

I have menu table:
 id          | integer | not null default
 nextval('public.menu_id_seq'::text)
 parent_id   | integer |
 description | text    |

 I do select:
 test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~')
 t(id integer, parent_id integer, level int, branch text);

id | parent_id | level |   branch
 ----+-----------+-------+-------------
   2 |           |     0 | 2
   4 |         2 |     1 | 2~4
   7 |         4 |     2 | 2~4~7
  10 |         7 |     3 | 2~4~7~10
  16 |        10 |     4 | 2~4~7~10~16
   9 |         4 |     2 | 2~4~9

How am I able to select description file from menu table,
not only id, parent_id, level, branch fields?

--
WBR, sector119