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

On 23/02/10 11:25, dipti shah wrote:
> Hi, could anyone please help me to sort out below error. I have spent lot of
> time but couldn't resolved it.

 > ERROR:  error from Perl function "test_create": syntax error at or near
 > "CREATE" at line 3.


> spi_exec_query("CREATE OR REPLACE FUNCTION my_tmp_func() RETURNS void AS
> $cmd LANGUAGE sql;");

You're interpolating $cmd here but not quoting it, so you end up with:
... RETURNS void AS CREATE TABLE test-table...
whereas you want:
... RETURNS void AS 'CREATE TABLE test-table...'...

Probably best to use dollar-quoting: $TMP$ or similar, but don't forget
to escapt the $ or perl will think it's a variable.

--
   Richard Huxton
   Archonet Ltd