CREATE OR REPLACE FUNCTION public.new_operation(
	auser_master_id integer,
	account_id integer,
	firm_id integer,
	user_id integer,
	id_kassa integer,
	id_simple_operation integer,
	typ_operation_id integer,
	id_contract integer,
	aoper_data timestamp with time zone,
	sum numeric,
	approved integer,
	coment character varying,
	sum1 numeric,
	id_project integer,
	tag character varying,
	id_partner integer,
	api integer,
	id_curency numeric,
	partner_id integer,
	id_sens_operation integer,
	id_opp integer)
    RETURNS text
    LANGUAGE 'plpgsql'

    COST 100
    VOLATILE 
AS $BODY$
DECLARE 
  tt INTEGER; --результат работы все процедуры
  typ_kassa_id INTEGER; --id типа счета касса или расчетный счет
  idd INTEGER; --id счета в плане счетов касса или расчетный счет
  idoper INTEGER; --id добавленной операции
  dd character varying;
  sens_operation INTEGER;
  
BEGIN
------------создание новой записи-----------------------------------------
 IF api=1 THEN  
  INSERT INTO operation("user_master_id","account_id","firm_id","user_id","id_kassa","id_simple_operation",
   "typ_operation_id","id_contract",
   "oper_data","sum","approved","Coment","sum1",
   "id_project","Tag","id_partner"
   )
  VALUES (auser_master_id ,account_id ,firm_id ,user_id ,id_kassa ,id_simple_operation ,
    typ_operation_id ,id_contract ,
    aoper_data ,sum ,approved ,Coment ,sum1 ,
    id_project , Tag, id_partner
   ) RETURNING id into idoper;
   dd=1;
 END IF;
----------Изменение записи---ОШИБКА ТУТ: firm_id="firm_id"------------------------------------------
 IF api=4 THEN  
  UPDATE operation SET "user_master_id"=auser_master_id, firm_id="firm_id",
  "user_id"=user_id, "id_kassa"=id_kassa, "id_simple_operation"=id_simple_operation,
   "typ_operation_id"=typ_operation_id, "id_contract"=id_contract,
   oper_data="aoper_data", sum="sum", approved="approved", "Coment"=Coment, "sum1"=sum1,
   "id_project"=id_project,"Tag"=Tag,"id_partner"=id_partner
    WHERE id = id_opp;
   dd=4;
 END IF;
-------------------------------------------------------------------------------------------------------- 
  RETURN dd; --результат завершения операции (успех или ошибка)
END;
$BODY$;