Re: another question about connectby from contrib

sector119@mail.ru wrote:
> ELECT f.*, link, text, target, icon, node FROM connectby('menu', 'id',
> 'parent_id', 8, 0) AS f(id integer, parent_id integer, level integer),
> menu where menu.id = f.id;
>
> I have got this:
>
>  id | parent_id | level | link |      text       | target | icon | node
> ----+-----------+-------+------+-----------------+--------+------+------
>   8 |           |     0 |      | #3         |        |      | t
>  11 |         8 |     1 |      | #3.1       |        |      | t
[...snip...]
>
> How am I able to get result where text field is like this:
>
> #3
> #3.1
[...snip...]

I don't see any difference. You'll have to be more clear with your question.

Joe