On Sun, Sep 18, 2011 at 10:55 PM, Ramanujam <innomot...@gmail.com> wrote: > The following bug has been logged online: > > Bug reference: 6213 > Logged by: Ramanujam > Email address: innomot...@gmail.com > PostgreSQL version: 9.0 > Operating system: linux x86_64 > Description: COPY does not work as expected in a plpgsql function > Details: > > A function like this: > > CREATE OR REPLACE FUNCTION test(parm character varying(3)) RETURNS SETOF > integer AS > $BODY$ > > BEGIN > COPY (SELECT $1) TO '/tmp/test.txt' CSV; > END; > > $BODY$ > LANGUAGE plpgsql VOLATILE COST 100 ROWS 100; > > Throws an error: > NUM:42P02, DETAILS:there is no parameter $1 > > Substrituting $1 with parm gives this error: > NUM:42703, DETAILS:column "parm" does not exist
Does it work if you use EXECUTE? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs