Удалить элемент с массива

CREATE TABLE test
(
test_id INTEGER,
test_names VARCHAR(64)[],
CONSTRAINT testpk PRIMARY KEY (test_id)
);

CREATE TABLE test_names_array (
test_names_id INTEGER PRIMARY KEY,
test_names_index INTEGER,
test_names_value VARCHAR(64),
);
 
CREATE TABLE testnew
(
test_id INTEGER PRIMARY KEY,
test_names INTEGER REFERENCES test_names_array(test_names_id)
);

CREATE TABLE test
(
  test_id INTEGER NOT NULL,
  test_names CHARACTER VARYING(64)[],
  CONSTRAINT testpk PRIMARY KEY (test_id )
);

CREATE TABLE testnew
(
  test_id INTEGER NOT NULL,
  CONSTRAINT testnew_pkey PRIMARY KEY (test_id )
);
CREATE TABLE testnew_names_array
(
  test_names_id INTEGER NOT NULL,
  test_names_index INTEGER NOT NULL,
  test_names_value CHARACTER VARYING(64),
  CONSTRAINT array_pk PRIMARY KEY (test_names_id , test_names_index ),
  CONSTRAINT array_fk FOREIGN KEY (test_names_id)
      REFERENCES testnew (test_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE
);

CREATE TABLE tbl_film
(
   film_id INTEGER,
   film_name CHARACTER VARYING(128),
   ....
   PRIMARY KEY (film_id)
);
CREATE TABLE tbl_genre
(
   genre_id INTEGER,
   genre_name CHARACTER VARYING(128),
   PRIMARY_KEY (genre_id)
);
CREATE TABLE tbl_film_genre
(
  film_id INTEGER,
  genre_id INTEGER,
  CONSTRAINT tbl_film_genre_film_id_fkey FOREIGN KEY (film_id)
      REFERENCES tbl_film (film_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT tbl_film_genre_genre_id_fkey FOREIGN KEY (genre_id)
      REFERENCES tbl_genre (genre_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE
);

INSERT INTO tbl (val) VALUES(mas_id)

UPDATE tbl SET val = mas_id ...

CREATE TABLE test
(
  id INTEGER NOT NULL,
  array_field INTEGER[],
  CONSTRAINT test_pkey PRIMARY KEY (id )
);

INSERT INTO test (id, array_field) VALUES (1, '{1,2,3,4,5,6,7,8,9}');
INSERT INTO test (id, array_field) VALUES (2, '{1,2,3,4,5,6,7,8,9}');
INSERT INTO test (id, array_field) VALUES (3, '{1,2,3,4,5,6,7,8,9}');

CREATE OR REPLACE FUNCTION deletebyvalue(in_array INTEGER[], del_index INTEGER)
  RETURNS INTEGER[] AS
$BODY$declare
  res INTEGER[];
  i INTEGER := 0;
  k INTEGER := 0;
BEGIN
  FOR i IN array_lower(in_array, 1)..array_upper(in_array, 1)
  loop
    IF in_array[i] = del_value
    THEN
      k = k + 1;
    ELSE
      res[i - k] = in_array[i];
    END IF;
  END loop;
  RETURN res;
END;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

UPDATE test SET array_field=deletebyvalue(array_field, 5);

1;"{1,2,3,4,6,7,8,9}"
2;"{1,2,3,4,6,7,8,9}"
3;"{1,2,3,4,6,7,8,9}"

CONSTRAINT array_pk PRIMARY KEY (test_names_id , test_names_index ),
  CONSTRAINT array_fk FOREIGN KEY (test_names_id)
      REFERENCES testnew (test_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE