-- -- tree_right/1 -- create or replace function tree_right( bit varying ) returns varbit as $$ -- Create a key greater or equal to that of any child of the current key. -- Used in BETWEEN expressions to select the subtree rooted at the given -- key. declare key alias for $1; begin if key is null then return 'XFFFFFFFF'::varbit; else return key || 'XFFFFFFFF'::varbit; end if; end;$$ language plpgsql;