Good day On Friday 05 September 2003 21:41, you wrote: > can anyone recommend a good reference source for doing recursive sql on > postgresql? i want to do something similar to a BOM expansion. (i.e. i need > to traverse a self-referencing table that stores a tree structure and > answer a question like "Get me A and all of A's descendents")
"recursive queries" are much slower than queries to a nested-tree. please find something readable on subject "nested-tree" or ask me to send you this. You'll see that the maintaining of a nested-tree is covered by its good profit. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html