PostgreSQL从十六进制转换为十进制

-- Function: hex_to_dec(text) 

-- DROP FUNCTION hex_to_dec(text); 

CREATE OR REPLACE FUNCTION hex_to_dec(in_hex text) 
  RETURNS integer AS 
$BODY$ 
  SELECT CAST(CAST(('x' || CAST($1 AS text)) AS bit(8)) AS INT); 
$BODY$ 
  LANGUAGE sql IMMUTABLE STRICT 
  COST 100; 
ALTER FUNCTION hex_to_dec(text) 
  OWNER TO postgres;