[why copy ? its not correct working outside static sytax ? ]

From: "R(dot)Tichy" <r(dot)tichy(at)sew-eurodrive(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: [why copy ? its not correct working outside static sytax ? ]
Date: 2002-05-10 06:25:28
Message-ID: 3CDB67D8.DA604490@sew-eurodrive.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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';

Responses

Browse pgsql-general by date

  From Date Subject
Next Message R.Tichy 2002-05-10 06:41:56 [wy copy dont't work with params]
Previous Message Thomas Lockhart 2002-05-10 01:18:37 Re: newbie - syntax question