Re: [sqlite] why does the recursive example sort alphabetically

2015-02-05 Thread RSmith
On 2015/02/04 15:45, Mark Summerfield wrote: Hi, In the documentation on page http://www.sqlite.org/lang_with.html there is an example of a recursive query if you scroll down to the heading "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER BY". The second example

Re: [sqlite] why does the recursive example sort alphabetically

2015-02-05 Thread Richard Hipp
On 2/4/15, Mark Summerfield wrote: > Hi, > > In the documentation on page http://www.sqlite.org/lang_with.html > there is an example of a recursive query if you scroll down to the heading > "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER

[sqlite] why does the recursive example sort alphabetically

2015-02-05 Thread Mark Summerfield
Hi, In the documentation on page http://www.sqlite.org/lang_with.html there is an example of a recursive query if you scroll down to the heading "Controlling Depth-First Versus Breadth-First Search Of a Tree Using ORDER BY". The second example under that heading shows how to get a depth-first