CREATE OR REPLACE FUNCTION update_office22()
  RETURNS trigger AS
$BODY$
DECLARE
  
    varoffice varchar(36);
    varlasttaskresultid varchar(36);
    
BEGIN

   
    IF    TG_OP = 'UPDATE' THEN
        varoffice = NEW.office;
	 
    
        select id into varlasttaskresultid from account where id=varoffice;

        UPDATE account set office='Офис №21' where id=varoffice and ownerid in ('12c326bc-992f-498d-b588-e872dc9e1137','ee3423ba-f6c6-4688-a8b1-2ff7defd70f1','d3672f92-436e-4223-5c3b-6297ef8616f1','db36369d-045d-4578-81b2-1bc4c3706539') ;
        RETURN NEW;
    END IF;
   
    
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;
ALTER FUNCTION update_office() OWNER TO postgres;