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