Re: Table-name as parameter to plpgsql

["Milen A. Radev" <milen(at)radev(dot)net>]

Andreas Joseph Krogh написа:
> The following function failes to compile:
>
> CREATE OR REPLACE FUNCTION test_func(p_table_name VARCHAR) RETURNS VOID AS $$
> BEGIN
>     INSERT INTO p_table_name(some_field) VALUES('some_value');
> END;
> $$ LANGUAGE plpgsql;
>
> Gives:
> ERROR:  syntax error at or near "$1"
> LINE 1: INSERT INTO  $1 (some_field) VALUES('some_value')
>
> Any hints on how to use function-parameters as table-names like I'm trying to 
> above?

Use EXECUTE 
(http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN).


--
Milen A. Radev