plpgsql and COPY
От | Joseph Bonnet |
---|---|
Тема | plpgsql and COPY |
Дата | |
Msg-id | 9h9tg7$4sd$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: plpgsql and COPY
|
Список | pgsql-general |
Hi, Y want to use COPY command in a PLpgSQL procedure like this: CREATE FUNCTION integration_salarie () RETURNS integer AS ' DECLARE hemp_r record; i integer := 0; emp_exist integer := 0; hnom varchar; hpnom varchar; hpos integer := 0; hcoddep varchar; BEGIN drop table tmphoremp; create table tmphoremp ( MATRI char(10), NOMPRE char(30), CCONT char(2), MDATREC char(8), DATCLO char(8), TYPCONT char(3), SOCPAIE char(2), HORSECT char(16) ); COPY tmphoremp FROM ''/home/public/intrasec/import/HOPEMP12.trs'' USING DELIMITERS ''\t''; IF NOT FOUND THEN RETURN -1; ELSE RETURN i; END IF; END; ' LANGUAGE 'plpgsql'; Y have always the response : CopyObjet: don't know to copy 610 What's wrong ? Thanks for your response. Joseph Bonnet.
В списке pgsql-general по дате отправления: