CREATE OR REPLACE FUNCTION public.*****(pnseason_id integer, pntournament_id integer)
 RETURNS void
 LANGUAGE plpgsql
 SECURITY DEFINER
AS $function$
DECLARE
  CUR RECORD;

BEGIN

  FOR CUR IN
    SELECT t.*,
           fm.id     id_c
      FROM (
            SELECT *
              FROM dbs_calendar  where season_id = pnSEASON_ID and tournament_id = pnTOURNAMENT_ID
           )   t
           LEFT JOIN ****** on (t.ID =  fm.ID)
     WHERE t.ts <> coalesce(fm.TS,('01.01.1990' :: TIMESTAMP(3)))
  LOOP

      PERFORM dbs_match_process(CUR.ID);
   
  END LOOP;

END;$function$
 

CREATE OR REPLACE FUNCTION public.dbs_match_process(pnmatch_id integer)
 RETURNS void
 LANGUAGE plpgsql
 STRICT SECURITY DEFINER
AS $function$
DECLARE
  rCALENDAR   dbs_calendar%ROWTYPE;
  

BEGIN
  RAISE NOTICE 'match = %',pnmatch_id;
  
  BEGIN
    SELECT t.*
      INTO STRICT
           rCALENDAR
      FROM dbs_calendar t
     WHERE t.ID = pnmatch_id;
  EXCEPTION  WHEN NO_DATA_FOUND THEN
    RAISE EXCEPTION 'DBS матч не найден с ID --> %', pnMATCH_ID;
  END;
END;$function$

SELECT t.*
      INTO STRICT
           rCALENDAR
      FROM dbs_calendar t
     WHERE t.ID = pnmatch_id;

with t (id) AS
(
  SELECT t.id
      FROM (
            SELECT *
              FROM dbs_calendar where season_id = 16 and tournament_id = 1
           )   t
           LEFT JOIN f_match fm  on (t.ID =  fm.ID)
     WHERE t.ts <> coalesce(fm.TS,('01.01.1990' :: TIMESTAMP(3)))
)

SELECT dbs_match_process(t.id)
   FROM t