recursing down a tree

Поиск
Список
Период
Сортировка
От Carl Meyer
Тема recursing down a tree
Дата
Msg-id jb0ohu86ct8g27ovvlvsn4rvous07am9fc@4ax.com
обсуждение исходный текст
Ответы Re: recursing down a tree  (Oleg Bartunov <oleg@sai.msu.su>)
Re: recursing down a tree  (Curt Sampson <cjs@cynic.net>)
Список pgsql-general
hi,

say i have a table with something like

id,parent,description

and parent points to an id of the very same table. now i have
a specific id and i want to recurse down the tree to the root.
is it in any way possible to do that without to doing a sql query
for each level ? until today i always saved the parent and formulated
a new query using it to get the next upper level. however, it seems to
me that this might be quite some work given a tree of a larger size.

thanks for your ideas
carl

В списке pgsql-general по дате отправления:

Предыдущее
От: "King King"
Дата:
Сообщение: The Rule does not working.
Следующее
От: "Tomis³aw Kityñski"
Дата:
Сообщение: Re: Wildcards in GROUP BY?