Re: frustrated by plpgsql procedure

Dino Vliet wrote:
> Hi guys,
>
> I trying for days to get this simple plpgsql procedure
> to run but I keep getting this error:
>
> psql:pgsql_procedure.txt:15: ERROR:  syntax error at
> or near  at character 17
> QUERY:  copy cancel TO $1 with delimiter as ',' null
> as '.'
> CONTEXT:  SQL statement in PL/PgSQL function doedit
> near line 12
> psql:pgsql_procedure.txt:15: LINE 1: copy cancel TO $1
>  with delimiter as ',' null as '.'
> psql:pgsql_procedure.txt:15:
>
> The source code of this plpgsql procedure is:
>
> create or replace function doedit() returns void AS $$
> /* Procedure to create textfile from database table.
> */
>
> DECLARE
> i integer := 340;
> start date :='2004-08-06';
> eind date :='2004-08-12';
> location varchar(30) :='/usr/Data/plpgtrainin';
>
> BEGIN
> create table cancel as (SOME QUERY);
> location := location || i || '.txt' ::varchar(30);
> raise notice 'location is here %', location;
> copy cancel TO location with delimiter as ',' null as
> '.' ;
> END
> $$ Language plpgsql;
>
Missing semi-colon after END?