Recursiv/hierarchical query?

[Ruslan Zasukhin]

On 1/22/09 1:49 AM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

Hi Bart,
Hi Thorsten,

1) not agree that DB should not walk by tree :)
    * actually Oracle, MS have own syntaxes to do this.
    * SQL 2003 also have solution for this task, although it seems ugly
        it needs write SQL query on 100 lines to get it as I have see,

2) Its issue of Relational model - it works with tables.

3) Valentina built as Object-Relational, so not moral issues to add trees
:-)


I suggest we all together think about this task.
I have show already how will looks 3 new API function.
Now we need invent nice SQL for these tasks.

Of course we need again look around on other dbs, then select best things.


> mmm, then we need to switch to a database that has OO in its roots...
> Oh no, wait.....

> On 21 Jan 2009, at 23:09, Thorsten Hohage wrote:

>> IMHO searching a list is a DB job, traversing a tree is a OO-concept.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]