By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,904 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,904 IT Pros & Developers. It's quick & easy.

Recursive Selects

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Varun Kacholia <va****@cse.iitb.ac.in> writes:
I wanted to know whether recursive selects are supported in the latest version
of postgres.


No. Some folks at Red Hat worked on it, but didn't finish in time for
7.4. It might show up in 7.5.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.