Syntax Error in COPY when “create function”

["hongliu zou" <zouhongliu(at)gmail(dot)com>]

 

Am I forgetting some limitation? 

 

I get " ERROR: syntax error at or near "$1"

SQL state: 42601 "with this

 

CREATE FUNCTION Import1() RETURNS text AS $$

DECLARE

            path Char(100);

BEGIN

            path = 'C:/zhl/hjs/anc_area.att';

            COPY anc_areaAtt FROM path CVS;

 

            RETURN path;

END;

$$ LANGUAGE plpgsql;

 

SELECT  Import1() ;

  

 

But COPY can work well when I just put the string in the command:

 

 

CREATE FUNCTION Import2() RETURNS text AS $$

DECLARE

            path Char(100);

BEGIN

            COPY anc_areaAtt FROM 'C:/zhl/hjs/anc_area.att' CSV;

            return path;

END;

$$ LANGUAGE plpgsql;

 

SELECT  Import2() ;

 

   

Does this mean the "filename" in COPY command can not be a variable?

 

By the way, my OS is windowXP.

 

Thanks and Regards,

Hongliu