PostgreSQL 错误 : EXECUTE of SELECT . .. INTO 未实现

Question

当我从我定义的函数运行以下命令时，我收到错误“EXECUTE of SELECT ... INTO is not implemented”。这是否意味着不允许使用特定命令(即“SELECT ...INTO”)？或者这只是意味着我做错了什么？导致错误的实际代码如下。如果答案已经在这里，我深表歉意，但是我看了看并没有找到这个特定的错误。在此先感谢...无论我运行 8.4.7 是什么值(value)

 vCommand = 'select ' || stmt.column_name || ' as id ' ||
            ', count(*) as nCount
            INTO tmpResults
            from ' || stmt.table_name || '
            WHERE ' || stmt.column_name || ' IN (select distinct primary_id from anyTable
                                                WHERE primary_id = ' || stmt.column_name || ')
            group by ' || stmt.column_name || ';';
EXECUTE vCommand;

Answer 1

INTO 在这个用例中是不明确的，然后在那里被禁止。

您可以改用 CREATE TABLE AS SELECT。

CREATE OR REPLACE FUNCTION public.f1(tablename character varying) RETURNS integer LANGUAGE plpgsqlAS $function$begin  execute 'create temp table xx on commit drop as select * from '                                       || quote_ident(tablename);  return (select count(*) from xx);end;$function$postgres=# select f1('omega'); f1 ────  2(1 row)