contrib/tablefunc/connectby question - Mailing list pgsql-general

test=# \d menu
id        | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
data      | text

I write query:

SELECT * FROM connectby('menu', 'id', 'parent_id', 1, 0)
AS t(id integer, parent_id integer, level integer);

and get only id, parent_id, level fields!
how am I able to get data field?

(only this way: SELECT id_, parent_id_, level, data FROM
connectby('menu', 'id', 'parent_id', 8, 0) AS t(id_ integer, parent_id_
integer, level integer), menu where menu.id = id_; ???)

--
WBR, sector119