Minor systax error but not able to resolve it... - Mailing list pgsql-general

Hi, could anyone please help me to sort out below error. I have spent lot of time but couldn't resolved it.

 

mydb=> CREATE OR REPLACE FUNCTION test_create()
  RETURNS void AS
$BODY$
$cmd = "CREATE TABLE test-table(col varchar not null);";
spi_exec_query("CREATE OR REPLACE FUNCTION my_tmp_func() RETURNS void AS $cmd LANGUAGE sql;");
$BODY$
  LANGUAGE 'plperl';
CREATE FUNCTION
mydb=> SELECT test_create();
ERROR:  error from Perl function "test_create": syntax error at or near "CREATE" at line 3.
mydb=>

 

I want to create function from my stored procedure in any language.

 

Thanks,

Dipti