CREATE OR REPLACE FUNCTION public.create_short_id("user_id_param" "uuid")
RETURNS "void"
LANGUAGE plpgsql SECURITY DEFINER
SET search_path = public, pg_temp
AS $$
BEGIN
SELECT id
FROM users
WHERE id = user_id_param;
INSERT INTO users(short_id)
values (id_encode(id));
END;
$$;
CREATE OR REPLACE FUNCTION public.create_short_id("user_id_param" "uuid")
RETURNS "void"
LANGUAGE plpgsql SECURITY DEFINER
SET search_path = public, pg_temp
AS $$
BEGIN
SELECT id
FROM users
WHERE id = user_id_param;
INSERT INTO users(short_id)
values (id_encode(id));
END;
$$;