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