如何在PostgreSQL中将以:分隔的十六进制ipv6字符串转换为十进制

我正在尝试将十六进制字符串转换为IPV6地址的数字列 十六进制输入为 2001:200:101:ffff:ffff:ffff:ffff:ffff 我的输出应该是 42540528727106952925351778646877011967 我尝试了以下从该站点获取的功能,通过使用 : 像 2001200101ffffffffffffffffffff

`CREATE OR REPLACE FUNCTION hex_to_int(hexval varchar) RETURNS numeric AS $$
DECLARE
  result  NUMERIC;
  i integer;
  len integer;
  hexchar varchar;
BEGIN

  result := 0;
  len := length(hexval);

  for i in 1..len loop
    hexchar := substr(hexval, len - i + 1, 1);
    result := result + 16 ^ (i - 1) * case
      when hexchar between '0' and '9' then cast (hexchar as int)
      when upper (hexchar) between 'A' and 'F' then ascii(upper(hexchar)) - 55
    end;
  end loop;

 RETURN result;
END;
$$
LANGUAGE 'plpgsql' IMMUTABLE STRICT;`

我得到的十进制数为

select hex_to_int('2001200101ffffffffffffffffffff');
              hex_to_int
--------------------------------------
 166176317495821453702777150266933247

如何获得我的实际十进制数?