非整型字段，如何实现哈希分区

drop table tbl;  
  
create table tbl (id text, info text, crt_time timestamp);  
  
do language plpgsql $$  
declare  
  parts int := 4;  
begin  
  for i in 0..parts-1 loop  
    execute format('create table tbl%s (like tbl including all) inherits (tbl)', i);  
    execute format('alter table tbl%s add constraint ck check(abs(mod(hashtext(id),%s))=%s)', i, parts, i);  
  end loop;  
end;  
$$;  
  
create or replace function ins_tbl() returns trigger as $$  
declare  
begin  
  case abs(mod(hashtext(NEW.id),4))  
    when 0 then  
      insert into tbl0 values (NEW.*);  
    when 1 then  
      insert into tbl1 values (NEW.*);  
    when 2 then  
      insert into tbl2 values (NEW.*);  
    when 3 then  
      insert into tbl3 values (NEW.*);  
    else  
      return NEW;  
    end case;  
    return null;  
end;  
$$ language plpgsql strict;  
  
create trigger tg1 before insert on tbl for each row when (NEW.id is not null) execute procedure ins_tbl();