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;