[DISCUSSION] Valentina SQL -- recursive search

[Ruslan Zasukhin]

On 2/4/09 1:12 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

Hi Bart,

> First questions for me is how do you specify what a descendant IS ?
> Shouldn't you specify a link name ?

Well, good point.

On API level if you have check this Mantis reports
>    http://www.valentina-db.com/bt/view.php?id=3958.
>    http://www.valentina-db.com/bt/view.php?id=3989.
>    http://www.valentina-db.com/bt/view.php?id=3960

It is part of Vlink method ...

For SQL we really must mention name of link somehow.
Damn, it is always good make discussion :-)

> Since it is entirely possible that a table is instead of a tree a
> matrix (more than one tree in the same table) but a self-join link is
> clear (identifies a specific tree in the table)

> So since it is possible to have multiple self-join links in the table,
> how will the proposed syntax handle the link to use ?

Okay, what about next improvement

WHERE (recid IN DESCENDANTS linkName OF (recID = 5) ON LEVEL 3)


-- 
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]