Re: another question about connectby from contrib

sector119(at)mail(dot)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