CREATE OR REPLACE FUNCTION public.get_json_value(json_data JSON, key TEXT)
RETURNS TEXT
LANGUAGE plpgsql
IMMUTABLE AS $$
BEGIN
   RETURN json_data ->> key;
END
$$;
CREATE INDEX IF NOT EXISTS video_additional_codec_idx ON public.video_additional(public.get_json_value(video_info, 'video_codec'));