On Apr 18, 2006, at 11:52 AM, Trausti Thor Johannsson wrote:
Thank you, but what if the sort order is not important, just that
children would come after the parent record ?
Same solution ? Or is that one possible with a single SQLite
command ?
Trausti
Basically this kid of traversal of a hierarchy is NOT possible in SQL
in a general way.
It requires some kind of iterative or recursive query which SQL
cannot do without some kind of language extensions.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
