postgresql – 在函数中使用postgres CTE的结果

create table directory (
  ID          seriaL PRIMary KEY,name      TEXT,parent_id integer REFERENCES directory(ID)
);

INSERT INTO directory (name,parent_ID)
VALUES ('Root',NulL),('D1',1),('D2',2),('D3',3);

我有这个递归CTE,它返回目录的后代.

WITH REcursIVE tree AS (
  SELECT ID
  FROM   directory
  WHERE  parent_ID = 2

  union all

  SELECT directory.ID
  FROM   directory,tree
  WHERE directory.parent_ID = tree.ID
)

返回的值是我所期望的,可以使其等于数组

SELECT (SELECT array_agg(ID) FROM treE) = ARRAY[3,4];

我可以使用数组从表中选择值

SELECT * FROM directory WHERE ID = ANY(ARRAY[3,4]);

但是,我无法使用CTE的结果来完成同样的事情.

SELECT * FROM directory WHERE ID = ANY(SELECT array_agg(ID) FROM treE);

结果错误表示存在类型不匹配.

HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

但是,我不确定如何正确地完成这个.