From: | "R(dot)Tichy" <r(dot)tichy(at)sew-eurodrive(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [wy copy dont't work with params] |
Date: | 2002-05-10 06:41:56 |
Message-ID: | 3CDB6BB4.B5360118@sew-eurodrive.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
subscribe-nomail
Hallo, erverybody !
I am working with Postgresql 7.2 on cygwin !
I have this problem inside from Database with functions and inside from
JDBC....
A Example :
create or replace function copy_data (varchar,varchar) returns varchar
as '
declare
aurl ALIAS FOR $1;
adelim ALIAS FOR $2;
begin
-- nice its work very fine with static param ...
copy transimport from ''/home/usrer/imports/trans.txt'';
-- where default \t is fieldseparator don't work with params wy ?
copy transimport from aurl;
--very very cosmic not for use in copy
--aurl := ''''''/home/user/imports/trans.txt'''''';
--raise notice ''killer: %'',aurl;
return ''ok-master'';
end;
' language 'plpgsql';
From | Date | Subject | |
---|---|---|---|
Next Message | Curt Sampson | 2002-05-10 07:49:29 | Re: Performance issues with compaq server |
Previous Message | R.Tichy | 2002-05-10 06:25:28 | [why copy ? its not correct working outside static sytax ? ] |