CREATE OR REPLACE FUNCTION public.temp_pl_unit2_4()
 RETURNS SETOF public.operation
 LANGUAGE plpgsql
AS $function$
  DECLARE viruchka_fact numeric :=0;
  DECLARE sebestoimost_fact numeric :=0;
  DECLARE summ numeric :=0;
begin

SELECT
 (Select SUM(public.operation.sum_acount_cur))+ 
   (SELECT case when SUM(public.operation.sum_acount_cur*-1) is null then 0 end
    FROM "public"."operation" 
    WHERE (public.operation.shot_debit_id = 138) 
     AND ( "public"."operation"."user_master_id"='8')
     AND ("public"."operation"."approved"='1')
     AND ("public"."operation"."plan_fakt"='1')
     AND ("operation"."oper_data" >= '01.01.2001' ::date OR "operation"."oper_data" = NULL)
     AND ("operation"."oper_data"< '01.03.2021' ::date+1 OR "operation"."oper_data"= NULL)
   ) INTO viruchka_fact
 FROM "public"."operation"
  WHERE ((public.operation.shot_credit_id = 135) OR (public.operation.shot_credit_id = 136)
   OR (public.operation.shot_credit_id = 137)) 
   AND ( "public"."operation"."user_master_id"='8')
   AND ("public"."operation"."approved"='1')
   AND ("public"."operation"."plan_fakt"='1')
   AND ("operation"."oper_data" >= '01.01.2001' ::date OR "operation"."oper_data" = NULL)
   AND ("operation"."oper_data"< '01.03.2021' ::date+1 OR "operation"."oper_data"= NULL); 
 
 SELECT  SUM(public.operation.sum_acount_cur) INTO sebestoimost_fact
  FROM "public"."operation"
  WHERE ((public.operation.shot_debit_id = 173) OR (public.operation.shot_debit_id = 174)
   OR (public.operation.shot_debit_id = 175)) 
   AND ( "public"."operation"."user_master_id"='8')
   AND ("public"."operation"."approved"='1')
   AND ("public"."operation"."plan_fakt"='1')
   AND ("operation"."oper_data" >= '01.01.2001' ::date OR "operation"."oper_data" = NULL)
   AND ("operation"."oper_data"< '01.03.2021' ::date+1 OR "operation"."oper_data"= NULL); 

--Вывод результата-----------------------------------------------------------
 summ=viruchka_fact-sebestoimost_fact;
 return query
 
 SELECT  '5. ' AS "Lavel-1", public."Directory_Language"."Name" AS "Type", '' AS "name_stat", '' AS "Firm", summ, '' AS "Partner", '' AS "Name_project"
 FROM public.operation 
   INNER JOIN public."Directory" ON (public."Directory".id=public.operation.plan_fakt)
   INNER JOIN public."Directory_Language" ON (public."Directory_Language".master_id=public."Directory".id)
 WHERE "public"."operation"."user_master_id"='8' 
   AND ("public"."operation"."approved"='1')
   AND ("public"."operation"."plan_fakt"='1')
   AND ("operation"."oper_data" >= '01.01.2001' ::date OR "operation"."oper_data" = NULL)
   AND ("operation"."oper_data"< '01.03.2021' ::date+1 OR "operation"."oper_data"= NULL)
   AND (public."Directory_Language".id_language='2');
  
end;
$function$

RETURNS TABLE("Lavel1" text, "Type" character varying, name_stat character varying, "Firm" character varying, summ numeric, "Partner" character varying, "Name_project" character varying)