Re: [GENERAL] variable in COPY TO variable

2007-10-18 Thread Rob Shepherd
> A case for dynamic > SQL!http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQ > L-STATEMENTS-EXECUTING-DYN > > Yours, > Laurenz Albe > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings P

[GENERAL] variable in COPY TO variable

2007-10-16 Thread Rob Shepherd
Dear postgres-users, I'm currently working on a stored procedure, but having an error which seems odd. I'm following the synatx COPY TO 'filename' .but i'm trying to use a variable as the filename. 1 : CREATE OR REPLACE FUNCTION archive() RETURNS void AS 2 : $BODY$DECLARE 3 : ts times