PG函数接受一个字符串作为数组

• 实例

CREATE OR REPLACE FUNCTION func_test(value_list varchar) 
RETURNS INTEGER 
AS
$BODY$
DECLARE
     val int;
BEGIN
          execute format('select 1  where 1=any(''%s'')',value_list) into val;

          RETURN val;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

select * from func_test('{1,2,3}');

• 结果

imos=# select * from func_test('{1,2,3}');
 func_test 
-----------
         1
(1 row)