这里有一个丑陋的解决方案（如果你绝望了），它应该在8.0上工作：
首先创建t10表，用作迭代器（将其调整为最大数组大小）：

CREATE TABLE T10 (ID INTEGER);

INSERT INTO T10 VALUES (1);
INSERT INTO T10 VALUES (2);
INSERT INTO T10 VALUES (3);
INSERT INTO T10 VALUES (4);
INSERT INTO T10 VALUES (5);
INSERT INTO T10 VALUES (6);
INSERT INTO T10 VALUES (7);
INSERT INTO T10 VALUES (8);
INSERT INTO T10 VALUES (9);
INSERT INTO T10 VALUES (10);

下面是测试表：

create table table1 (
    ids text[]
);

insert into table1 (ids) values (ARRAY['ID_two','ID_four']);

select * from table1;

       ids        
------------------
 {ID_two,ID_four}

然后，查询，使用T10迭代数组的所有成员：

\set myids ARRAY['''ID_one''','''ID_two''','''ID_three''']

select *
  from (
     select ids[iter.pos] as ids
     from table1
     join (select id as pos from t10) iter
     on iter.pos <= array_length(ids,1)) as A
  join (
     select (:myids)[iter.pos] as ids
     from (select id as pos from t10) iter
     where iter.pos <= array_length(:myids,1)) as B
  on a.ids = b.ids;

  ids   |  ids
--------+--------
 ID_two | ID_two