[NEW][SQL] direction for recursive links, for syntax USING LinkName

[Ruslan Zasukhin]

Hi All,

We have extend this for 4.0 to be as

join_specification
    :    ON ( link_name [ParentDirection | ChildDirection]



--------------
And we have improve things for syntax of FK and ObjectPTr

    T a JOIN T b ON a.id = b.ptr


Now SQL engine will take care on this condition to pass info about which
table a or b belongs ID field, and to which PTR.

So you can control direction on recursive links:

    search childs of Peter or search his parents ...



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