Recursive Selects
| От | Varun Kacholia |
|---|---|
| Тема | Recursive Selects |
| Дата | |
| Msg-id | 20030903142228.A8231@cse.iitb.ac.in обсуждение |
| Ответы |
Re: Recursive Selects
|
| Список | pgsql-general |
Hello All, I wanted to know whether recursive selects are supported in the latest version of postgres. I checked out the unimplemented sql constructs and came to know that "with recursive" is supported in 7.3, but i could not find any documentation for it. Actually I have a DB containing the adjancency list (ie tuples of type node1 node2 where the graph has an edge between node1 and node2) for a graph. Now given any node i need to find out all its neighbours till a depth of say 5. Hence i need a recursive select (to avoid giving individual selects as it might take longer and i am concerned about speed). Sorry if this is a repost, but i could not find much info in the archieves. Any help would be appreciated. TIA -- Varun
В списке pgsql-general по дате отправления: