> 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
Rob Shepherd wrote:
> I'm following the synatx
>
> COPY TO 'filename'
>
> .but i'm trying to use a variable as the filename.
>
[...]
>
> returns the error
>
> ERROR: syntax error at or near "$1" at character 21
> QUERY: COPY tt_archive TO $1
> CONTEXT: SQL statement in PL/PgSQL funct
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
