error while generating and EXECUTEing a query dynamically - Mailing list pgsql-general

Hi all,

The machine I am sending this mail from does not have postgres, but I
did this just this morning so am typing from memory:

<code>

CREATE FUNCTION footable() RETURNS INTEGER AS '

DECLARE
    sql VARCHAR(1000);

BEGIN

      sql := ''CREATE TABLE foo (x INT, y CHAR) '';

      EXECUTE sql;

      RETURN 1;

END;
' LANGUAGE 'plpgsql';


<code>


Now when I try to execute this function I get an error message saying

<error>
parse error at or near ""
<error>


I will get the exact function and error output from other machine
tomorrow (the actual query I am generating is more complex) but in the
meantime if anyone can help with this example, I would be most
grateful. Where am I going wrong?

TIA

Gaurav