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