Re: frustrated by plpgsql procedure

Nope:-(

I added it just now and still the same error message!!



--- Bricklen Anderson <banderson@presinet.com> wrote:

> 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?
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com