-- -- tree_root_key/1 -- create or replace function tree_root_key( bit varying ) returns varbit as $$ -- Return the tree_sortkey for the root node of the node with the -- given tree_sortkey. declare p_tree_key alias for $1; begin if substring(p_tree_key, 1, 1) = '1' then return substring(p_tree_key, 1, 32); else return substring(p_tree_key, 1, 8); end if; end;$$ language plpgsql;