CREATE OR REPLACE FUNCTION public.hex_to_int(hexval varchar)
RETURNS integer AS $$
DECLARE
   result  int;
BEGIN
 EXECUTE 'SELECT x''' || hexval || '''::bigint' INTO result;  RETURN result;
END;
$$ LANGUAGE 'plpgsql' IMMUTABLE STRICT;

arrow
arrow
    全站熱搜

    graciasnana 發表在 痞客邦 留言(0) 人氣()