Re: [PERFORM] Immutable table functions

2010-02-12 Thread Yeb Havinga
Luiz Angelo Daros de Luca wrote: I have a directed graph, or better, a tree in postgresql 8.3. One table are the nodes and another one are the connections. Given any node, I need to get all nodes down to it(to the leafs) that have relation with anotherTable. Also, this connection change on ti

[PERFORM] Immutable table functions

2010-02-12 Thread Luiz Angelo Daros de Luca
Hello guys, I don't know if this is the correct list. Correct me if I'm wrong. I have a directed graph, or better, a tree in postgresql 8.3. One table are the nodes and another one are the connections. Given any node, I need to get all nodes down to it(to the leafs) that have relation with anot