Re: Proper siblings sorting in nested sets model

>> Nested sets .. seems like it's impossible to order node siblings by
some arbitrary parameter .. <<

I'd convert a nested sets model into an adjacency list model and add the arbitrary sort parameter, something like this:

SELECT B.emp AS boss, E.emp, F1.arbitary_parm   FROM (OrgChart AS E

        LEFT OUTER JOIN
        OrgChart AS B
        ON B.lft
           = (SELECT MAX(lft)
                FROM OrgChart AS S
               WHERE E.lft > S.lft
                 AND E.lft < S.rgt))
       INNER JOIN
       SELECT F1.arbitary_parm
         FROM Foobar AS F1
        WHERE {{ something with B.emp and/or E.emp }}