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.