> ...I'd like to use a table as a "pure" BTree ... If you mean a general multi-way B-Tree, I don't think there's any practical way in SQL. If you can use a binary tree, there are ways. The most convenient is Joe Celko's method, which he calls nested sets. The other design is usually called an adjacency list. There was a discussion of this topic on this mailing list about a year ago.
You might search the list archive and also try a Google search on 'celko nested set' and 'adjacency list' -- or even just 'sql tree'. Regards
