Re: Other tree representations in SQL

"Carl Rosenberger" <carl_at_db4o.com> wrote in message news:<askvnj$pr9$03$1_at_news.t-online.com>...

> I challenge any relational system to provide the same functionality with
> an equally small number of lines of code. I challenge any relational
> system for a performance race on any kind of tree search or tree traversal.

I have counted 131 lines.

This is a solution using Tutorial D:

var Tree = real relation { N Char, P Char } key { N, P };
Tree := relation { tuple { 'A', 'A' }, tuple { 'B', 'A' }, tuple { 'C', 'A' },
                   tuple { 'D', 'B' }, tuple { 'E', 'B' }, tuple { 'F', 'C' },
                   tuple { 'G', 'C' } };