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

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Jan 27 07:56:59 CST 2009


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]




More information about the Valentina mailing list