Re: does mysql5.0 support recursive queries?

[grass grass]

Thank you Bill.
Is that true? What prohibited Joe Celko to do so? Do you think recursive queries can solve this? As fas as I can perceive, the loop of the edges and disconnectivity causes the problem.

Here's what I found of the book's content:

Contents

1 Graphs, Trees and Hierarchies
1.1 Modeling a Graph in a Program 1.1.1 Adjacency Lists for Graphs 1.1.2 Adjacency Arrays for Graphs 1.1.3 Finding a path in a General Graphs in SQL 1.2 Defining Tree and Hierarchies 1.2.1 Trees 1.2.2 Properties of Hierarchies 1.2.3 Types of Hierarchies 1.3 Note on Recursion

It seems it is right dealing with graphs, isn't it?