Please help me to take a look of the erros in my functions. Thanks.

I tried to create function to truncate table
1) when the user call the function just specify the tablename
2) the user can use the function owner privilege to execute the function.

But I got the errors as follows. Please help me to take a look.

Thanks.

Regards.

Grace
------ function :

CREATE OR REPLACE FUNCTION truncate_t(tablename IN VARCHAR) RETURNS void AS
$$
 DECLARE
     stmt RECORD;
     statements CURSOR FOR SELECT tablename FROM pg_catalog.pg_tables;
 BEGIN
     IF stmt IN statements then
         EXECUTE 'TRUNCATE TABLE ' || quote_ident(stmt.tablename) || '
CASCADE;';
 ELSE
     The tablename doesn't exist.doesn
     END IF ;
 END;
 $$ LANGUAGE 'plpgsql' security definer;

---- errors.
ERROR:  syntax error at or near "$2"
LINE 1: SELECT   $1  IN  $2
                         ^
QUERY:  SELECT   $1  IN  $2
CONTEXT:  SQL statement in PL/PgSQL function "truncate_t" near line 6

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Please-help-me-to-take-a-look-of-the-erros-in-my-functions-Thanks-tp5613507p5613507.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.