--
-- util__computehash/1
--
create or replace function util__computehash(
character varying
) returns varchar as $$
declare
v_value alias for $1;
v_hashed char(40);
begin
select RAWTOHEX(util__computehash_raw(v_value)) into v_hashed;
return v_hashed;
end;$$ language plpgsql;