CREATE TABLE "TEST"
(
  "ID" bigint NOT NULL DEFAULT nextval('"ID_seq"'::regclass),
  "ID_TEST" bigint,
  CONSTRAINT "TEST_pkey" PRIMARY KEY ("ID")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "TEST"
  OWNER TO postgres;

CREATE OR REPLACE FUNCTION test(INOUT id_array bigint[], INOUT resultcode integer)
  RETURNS record AS
$BODY$
DECLARE
--	diagnostics_int_ar integer;
begin
		EXECUTE 'insert into "TEST"("ID_TEST") select unnest(a) from (select $1 as a) foo' 
		USING id_array;


--		GET DIAGNOSTICS diagnostics_int_ar = ROW_COUNT; 	    						
--		IF diagnostics_int_ar THEN resultcode := 0;
--		ELSE resultcode := 1; 
--		END IF;

end;
$BODY$
  LANGUAGE plpgsql 

select test(array[1,2,3], -1);

		EXECUTE 'insert into "TEST"("ID_TEST1", "ID_TEST2") select unnest(a), unnest(b) from (select $1 as a, $2 as b) foo' 
		USING id_array1, id_array2;

insert into "TEST"("ID_TEST1", "ID_TEST2") select unnest(a), unnest(b) from (select array[1,3,5] as a, array[9,8,7] as b) foo;

ID     ID_TEST1   ID_TEST2
 1        1           9
 2        3           8
 3        5           7

ID     ID_TEST1   ID_TEST2
 1        1           1
 2        3           1
 3        5           1

select ((select "ID_TEST" from "TEST") && ARRAY[1,2,3]);

ОШИБКА:  ОШИБКА:  оператор не существует: integer && integer[]
LINE 5: select ((select "ID_TEST" from "TEST") && ARRAY[1,2,3]);
                                               ^
HINT:  Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные преобразования типов.