Postgres PL/SQL fnv1a 32 bit hash function for strings

fnv1a_32.sql

CREATE OR REPLACE FUNCTION public.hash_fnv1a_32(
	p_data character varying,
	p_init bigint DEFAULT '2166136261'::bigint,
	p_prime bigint DEFAULT 16777619)
    RETURNS bigint
    LANGUAGE 'plpgsql'
    COST 100
    STABLE PARALLEL SAFE
AS $BODY$
DECLARE
	v_hval bigint;
	ch char;
BEGIN
	v_hval := p_init;
	FOREACH ch IN ARRAY regexp_split_to_array(p_data, '')
	LOOP
		v_hval := v_hval # ASCII(ch);
		v_hval := (v_hval * p_prime) % 4294967296;
	END LOOP;
	RETURN v_hval;
END;
$BODY$;