PostgreSQL склад

/* Сам тип расхода */
CREATE TYPE  ComprositiontRashod AS (
    Name CHARACTER VARYING,
    COUNT NUMERIC
);
 
/* Таблица самого склада */
CREATE TABLE "Sklad" (
    "Name" CHARACTER VARYING NOT NULL,
    "Uint" CHARACTER VARYING NOT NULL,
    "Count" NUMERIC,
    "Changed" BOOLEAN, /* эти поля для 1с */
        "OneCID" CHARACTER VARYING, /* эти поля для 1с */
    CONSTRAINT Sklad_pk PRIMARY KEY ("Name")
) WITH (
  OIDS=FALSE
);
 
/* таблица для расхода */
CREATE TABLE "Rashod" (
    "ID" serial NOT NULL,
    "Date" TIMESTAMP WITHOUT TIME zone NOT NULL,
    "NameSklad" CHARACTER VARYING NOT NULL,
    "Composition" ComprositiontRashod[] NOT NULL,
    "Operator" CHARACTER VARYING NOT NULL,
    "Total" NUMERIC NOT NULL,
    "Changed" BOOLEAN,
        "OneCID" CHARACTER VARYING,
    CONSTRAINT Rashod_pk PRIMARY KEY ("ID")
) WITH (
  OIDS=FALSE
);
 
/* Для калькуляции */
CREATE TABLE "Calculation" (
    "Name" CHARACTER VARYING NOT NULL,
    "Gor_Obrabotka" NUMERIC ,
    "Hol_Obrabotka" NUMERIC ,
    "Exit_procent" NUMERIC,
    CONSTRAINT Calculation_pk PRIMARY KEY ("Name")
) WITH (
  OIDS=FALSE
);
 
/* Активные продукты на точке */
CREATE TABLE "ActivSklad" (
    "Name" CHARACTER VARYING NOT NULL,
    "Count" NUMERIC NOT NULL,
    CONSTRAINT ActivSklad_pk PRIMARY KEY ("Name")
) WITH (
  OIDS=FALSE
);

CREATE OR REPLACE FUNCTION rashod_trigger_func() RETURNS TRIGGER AS $TRIGGER$
DECLARE
    rec ComprositiontRashod;
    counts NUMERIC;
    allcount NUMERIC;
    SQL VARCHAR;
    sqlUpdate VARCHAR;
    sqlSelect VARCHAR;
    nameSklad VARCHAR;
 
BEGIN 
    nameSklad :=  (SELECT  "Rashod"."NameSklad" FROM "Rashod" WHERE NEW."ID" = "Rashod"."ID" );
    SQL :='select "Count" from ' || nameSklad || ' s Where s."Name" = $1';  
    sqlUpdate := 'UPDATE '|| nameSklad ||' SET "Count"= ($1 - $2)  WHERE '|| nameSklad ||'."Name" = $3 AND '|| nameSklad ||'."Count" >= $2';
    sqlSelect := 'select "Count" from '|| nameSklad ||' s Where s."Name" = $1';
 
    FOR rec.Count, rec.Name IN SELECT u.Count, u.Name FROM  unnest(NEW."Composition") u  GROUP BY u.Count, u.Name
    LOOP
      EXECUTE SQL INTO counts USING rec.Name;
      EXECUTE sqlUpdate USING counts, rec.Count, rec.Name;
      EXECUTE sqlSelect INTO allcount USING rec.Name;
      IF allcount = counts THEN
        RAISE EXCEPTION 'Error';
      END IF;
    END LOOP;
    RETURN NEW;
END;
$TRIGGER$
LANGUAGE  plpgsql;
 
CREATE TRIGGER rashod_trigger
AFTER INSERT OR UPDATE ON "Rashod" FOR EACH ROW 
EXECUTE PROCEDURE rashod_trigger_func();

CREATE OR REPLACE FUNCTION rashod_trigger_func() RETURNS TRIGGER AS $TRIGGER$
DECLARE
    rec ComprositiontRashod;
    counts NUMERIC;
    allcount NUMERIC;
    SQL VARCHAR;
    sqlUpdate VARCHAR;
    sqlSelect VARCHAR;
    nameSklad VARCHAR;
 
BEGIN 
    nameSklad :=  (SELECT  "Rashod"."NameSklad" FROM "Rashod" WHERE NEW."ID" = "Rashod"."ID" );
    SQL :='select "Count" from ' || nameSklad || ' s Where s."Name" = $1';  
    sqlUpdate := 'UPDATE '|| nameSklad ||' SET "Count"= ($1 - $2)  WHERE '|| nameSklad ||'."Name" = $3 AND '|| nameSklad ||'."Count" >= $2 RETURNING '|| nameSklad ||'."Count"';
    sqlSelect := 'select "Count" from '|| nameSklad ||' s Where s."Name" = $1';
 
    FOR rec.COUNT, rec.Name IN SELECT u.COUNT, u.Name FROM  unnest(NEW."Composition") u  GROUP BY u.COUNT, u.Name
    LOOP
      EXECUTE SQL INTO counts USING rec.Name;
      EXECUTE sqlUpdate  INTO allcount USING counts, rec.COUNT, rec.Name;
     /* EXECUTE sqlSelect INTO allcount USING rec.Name;*/
      IF allcount = counts THEN
        RAISE EXCEPTION 'Error';
      END IF;
    END LOOP;
    RETURN NEW;
END;
$TRIGGER$
LANGUAGE  plpgsql;
 
CREATE TRIGGER rashod_trigger
AFTER INSERT OR UPDATE ON "Rashod" FOR EACH ROW 
EXECUTE PROCEDURE rashod_trigger_func();