CREATE OR REPLACE FUNCTION public.insert_similar_hash_missing_units_func( user_id integer ) RETURNS void LANGUAGE plpgsql AS $$ BEGIN INSERT INTO similar_hash (id_unit, id_user, takentime, is_major, id_item) SELECT unit.id, unit.id_user, unit.takentime, unit.is_major, unit.id_item FROM unit LEFT JOIN similar_hash ON unit.id = similar_hash.id_unit WHERE similar_hash.id_unit IS NULL and unit.id_user = user_id; END; $$;